SqlServer:
select top n COLUMNNAME from TABLENAME;
eg: select top 2 * from customer;
ORACLE:
select COLUMNNAME from TABLENAME where ROWNUM<=n;
eg: select name from customer where rownum<=3;
MySql:
SELECT COLUMNNAME from TABLENAME LIMIT n;
eg:select name form customer limit 3;
select top n COLUMNNAME from TABLENAME;
eg: select top 2 * from customer;
ORACLE:
select COLUMNNAME from TABLENAME where ROWNUM<=n;
eg: select name from customer where rownum<=3;
MySql:
SELECT COLUMNNAME from TABLENAME LIMIT n;
eg:select name form customer limit 3;