doubt regarding SQL

[65daysofstatic]

hi,

I am new to SQL, and I am wondering if there's a way to select the first tuple/row of a table.

65dos.

[cabalas]

This code should select the first row from a table


select * from table_name limit 1

[CptPicard]

First of all, without an order by clause, SQL does not specify an ordering, so there is no well-defined "first" row. Otherwise, use a "LIMIT 1" at the end of the query.

[65daysofstatic]

lol sql server doesn't support the clause limit but it helped me to find the clause set rowcount and top.

Thank you.