Get first row in Db2

Hilarious Hare answered on July 29, 2022 Popularity 1/10 Helpfulness 1/10

answer Get first row in Db2

Comment

SELECT * FROM table_name WHERE id=(SELECT min(id) FROM table_name)
SELECT * FROM table_name ORDER BY id FETCH FIRST ROW ONLY

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: db2 get row sql

Link to this answer
Share Copy Link

Contributed on Jul 29 2022

Hilarious Hare

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.