我如过取表中的前三行如何写select * from ss;

[azxsqw]

我如过取表中的前三行如何写select * from ss;
用什么关键字？

[dgyujingjun]

select * from ss top 3

[Memocs]

select top 3 * from ss

[chensuper]

select * from ss top 3
很简单的呀！

[stonewang]

、、、
String sql="select top 3 * from ss";
ResultSet rs=stmt.executeQuery(sql);
、、、

[zhaoxichao]

sqlserver：select top 3 * from ss
oracle：select * from ss where rownum <=3

[emoam]

select * from ss top 3 !!!!!!!!?????????

"select top 3 * from ss" is true

[runaway]

(mysql) select * from ss limit 3
(sql server) select top 3 * from ss

[lynx1111]

总结：
(mysql) select * from ss limit 3
(sql server) select top 3 * from ss
oracle：select * from ss where rownum <=3

[drhhdq]

(sql server) select top 3 from 表名字tbname order by 排序的字段名字

[jsidiot]

select top 3 * from table where .....

[leshui]

select top 3 * from...

[LingFengNB]

sql server：sql="select top 3 * from ss order by 排序的字段"
mysql：sql="select * from ss limit 3"
oracle：sql="select * from ss where rownum <=3"
ResultSet rs=stmt.executeQuery(sql);

[zhoukai1980]

来晚了，呵呵
那就up

[michaelsheyong]

(mysql) select * from ss limit 3
(sql server) select top 3 * from ss
orcale没有用过,不知道

[whyxx]

select * from (select * from table_name order by id desc) where rownum<4;

[Wnyu]

mark