1.搜索前十条数据
sql server:select top 10|percent mobile,userId from user_
my sql: select mobile,userID from user_ limit 10 / select * from user_ limit 10
oracle: select * from user_ where ROWNUM<10
1.搜索前十条数据
sql server:select top 10|percent mobile,userId from user_
my sql: select mobile,userID from user_ limit 10 / select * from user_ limit 10
oracle: select * from user_ where ROWNUM<10