Re: [GENERAL] only the last 3 records

2008-09-27 Thread A. Kretschmer
am Sat, dem 27.09.2008, um 9:13:48 +0200 mailte Alain Roger folgendes: > Hi, > > maybe it's a stupid question, but i do not remember how to query a table and > to > request only the latest 3 added records. > How can i do that (i have a field time and a field date) ? ... order by desc limit 3;

[GENERAL] only the last 3 records

2008-09-27 Thread Alain Roger
Hi, maybe it's a stupid question, but i do not remember how to query a table and to request only the latest 3 added records. How can i do that (i have a field time and a field date) ? thx. -- Alain Windows XP SP3 PostgreSQL 8.2.4 / MS SQL server 2005 Apache