How do I select only 1 row in sybase without using
rowcount? I don't have the privilege to
set rowcount in sybase. Is there a way to select only 1 row?
select * from table where name = 'jack'
This returns two rows; how do I select only one row from the result set without using
Try the query:
SELECT TOP 1 * FROM mytable WHERE name = 'jack'
As you might guess, this selects the TOP 1 matching results. If you wanted more (which you don't here) you could use any number (
TOP 100 or
TOP 1000, etc).
A more comprehensive example can be found on w3schools: http://www.w3schools.com/Sql/sql_top.asp