、、、 String sql="select top 3 * from ss"; ResultSet rs=stmt.executeQuery(sql); 、、、
sqlserver:select top 3 * from ss oracle:select * from ss where rownum <=3
select * from ss top 3 !!!!!!!!?????????"select top 3 * from ss" is true
(mysql) select * from ss limit 3 (sql server) select top 3 * from ss
总结: (mysql) select * from ss limit 3 (sql server) select top 3 * from ss oracle:select * from ss where rownum <=3
(sql server) select top 3 from 表名字tbname order by 排序的字段名字
select top 3 * from table where .....
select top 3 * from...
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);
select * from (select * from table_name order by id desc) where rownum<4;
(mysql) select * from ss limit 3 (sql server) select top 3 * from ss orcale没有用过,不知道
很简单的呀!
String sql="select top 3 * from ss";
ResultSet rs=stmt.executeQuery(sql);
、、、
oracle:select * from ss where rownum <=3
(sql server) select top 3 * from ss
(mysql) select * from ss limit 3
(sql server) select top 3 * from ss
oracle:select * from ss where rownum <=3
mysql:sql="select * from ss limit 3"
oracle:sql="select * from ss where rownum <=3"
ResultSet rs=stmt.executeQuery(sql);
(sql server) select top 3 * from ss
orcale没有用过,不知道