Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 221-230 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

63	T-SQL	Datenbank	Tabellenstruktur kopieren	Select * INTO SQL2.dbo.NeueTabelle FROM SQL1.dbo.AlteTabelle WHERE 0=1
219	ORACLE PL/SQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100
10	MySQL	Datenbank	Lesen Datensatzes	SELECT * FROM myTable WHERE id=1; SELECT field2,field17 FROM myTable WHERE id=1 AND name='test'; SELECT field3,field1 FROM myTable WHERE city like '%ew Yor%';
218	MySQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT * FROM tableA LIMIT 100;
123	PL/pgSQL	Datum, Zeit	Alter zu gegebenen Datum ermitteln	select age({ts '1983-08-21 17:25:00'})
181	PL/pgSQL	Datenbank	NULL Wert eines Feldes übersteuern	SELECT COALESCE(MyColumn1, 1.0) AS MyColumnWithoutNULL;
235	MySQL	Datenbank	Aktuellen Datenbanknamen ausgeben	SELECT DATABASE() AS DB_Name;
169	SQLite	Datum, Zeit	Aktuelles Datum/Uhrzeit	select date('now'); select time('now'); select datetime('now');
171	SQLite	Datum, Zeit	Gestriges Datum	select date('now','-1 day');
168	SQLite	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	select date('now','start of month'); --first day of current month select date('now','start of month', '+1 months','-1 day'); --last day of current month