selecting 3 table entries out of 5

[Peter82]

How can i select the first 3 data records out of a sorted tabel with for example 5 dara records

 

[tlbroadbent]

Select Top 3 col1, col2, col3, col4, ...
From table
Order By col1, col2, ... Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Peter82]

I made a big mistake
How could i select 3 of each group in a table

 

[tlbroadbent]

Use a correlated sub query to select the top three by group and the outer query to select for all groups.

SELECT t1.groupid, t1.col2, t1.col3, ...
FROM table t1
WHERE t1.col2 IN
(SELECT TOP 3 t2.col2 FROM table t2
WHERE t2.groupid=t1.groupid)
ORDER BY t1.groupid, t1.col2;
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.