取数据库表前N条记录，对于的SQL

 /*取一表前N条记录，各个数据库的SQL写法：
       1. ORACLE             SELECT * FROM TABLE1 WHERE ROWNUM<=N
       2. DB2                SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N
          DB2                SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY
       3. SQL SERVER         SELECT TOP N * FROM TABLE1
       4. mysql:             select * from table_name limit N
/*获取随机记录的前N条记录

  1、db2:SELECT * FROM MYTABLE ORDER BY rand() DESC FETCH FIRST N ROWS ONLY
  2、sqlserver:SELECT top 10 * FROM userinf ORDER BY  NEWID()
  3、mysql: select * from tablename order by rand() limit 10