How to Query by line in SQL

Question

I have the query and table below, how do I select the 1st line of each category of column TeamboardId?

SELECT * FROM Job WHERE HandLingTimeSeconds = '60'

JobId	TeamboardId
1	1
2	1
3	1
4	2
5	2
6	2

The expected result should be

JobId	TeamboardId
1	1
4	2

If the data always has this form or if you always want to get the lowest JobId per TeamboardId, just write SELECT MIN (JobId), TeamboardId FROM job GROUP BY TeamboardId; — Jonas Metzler, Nov 25 '22 at 17:02

score 0 · Accepted Answer · answered Nov 25 '22 at 16:55

You can probably use a window function such as ROW_NUMBER() like in the below query :

WITH j AS
(
 SELECT Job.*, ROW_NUMBER() OVER (PARTITION BY TeamboardId ORDER BY JobId) AS rn 
   FROM Job
  WHERE HandLingTimeSeconds = '60'
)
SELECT *
  FROM j
 WHERE rn = 1

How to Query by line in SQL

1 Answers1