SV: Subselect or other way?

2002 08:13 Till: [EMAIL PROTECTED]; Jonny Stendahl Ämne: AW: Subselect or other way? I think my english ist too bad My table looks like this id nr --- 1 123 1 456 1 678 2 457 2 897 2 123 I want to select in a query only these id that have

SV: returning top two values

Hi Rich, Use the LIMIT 2 and sort the SELECT with ORDER BY family ID DESC // Jonny -Ursprungligt meddelande- Från: R.Dobson [SMTP:[EMAIL PROTECTED]] Skickat: den 21 maj 2002 14:57 Till: [EMAIL PROTECTED] Ämne: returning top two values Hi, I have a table containing data

SV: Subselect or other way?

This is a simple SELECT statement: SELECT id FROM Table WHERE nr=3D123 AND id = 3D456 this gives you probably one record, or you could use OR: SELECT id FROM Table WHERE nr=3D123 OR id = 3D456 this gives you all records with nr 3D123 OR id 3D456 // Jonny