Oracle语法:select column_name(s) form table_name where rownum<= number mysql语法:select column_name(s)from table_name limit number like select column_name(s) from table_name where column_name like pattern 通配符(%,_