Question

有一个sql语句，我通过select检索出三条，但是我只想要第一条应该怎么写？

select firstname from table1 where firstname = ‘zhang’
这个语句一下搜索出三条 我就想要第一条应该怎么写

Answer 1

SQL SERVER
select top 1 firstname from table1 where firstname = 'zhang'
ORACLE
select firstname from table1 where firstname ='zhang' where rownum=1

另外zhang外面的单引号不能用中文输入法的

Answer 2

select firstname from table1 where firstname = ‘zhang’limit 1;

这样就OK了。

Answer 3

select firstname from table1 where firstname = 'zhang'

Answer 4

select top 1 firstname from table1 where firstname = ‘zhang’

Answer 5

select top 1 firstname from table1 where firstname = ‘zhang’