mysql、oracle、sqlserver中只显示前几条记录的语法
2009-04-30 23:51
sqlserver中显示前几条记录的格式为:
select top number|percent column_name(s) from table_name;
例如:select top 3 name,age from student;
mysql与oracle中显示指定的前几条记录的格式为:
select column_name(s) from table_name limit number;
例如:select name,age from student limit 3;