SQL statement for mysql, Oracle, and mssql to retrieve the first few pieces of data

The following describes how to write SQL statements for mysqlOraclemssql to retrieve the first few pieces of data. For more information, see.

The following describes how to write SQL statements for mysql/Oracle/mssql to retrieve the first few pieces of data. If you need them, refer to them.

The following describes how to write SQL statements for mysql/Oracle/mssql to retrieve the first few pieces of data. If you need them, refer to them.

If you use this statement in ms sqlserver:

The Code is as follows:
Select top 2 * from test01

Oracle statement:

The Code is as follows:
Select * from (select rownum r, * from test) ttwhere tt. r> 50 and tt. r <= 100;

(It is best to use PLSQL cursor to solve this problem)

In DB2:

The Code is as follows:
Select * from payment fetch first 5 row only -- query the first 5 Records

MSSQL

If you use this statement in ms sqlserver:

The Code is as follows:
Select top 2 * from test01

Only the first two records are displayed,

MYSQL can use limit.

The Code is as follows:
Select * from your_table where... limit 2;

One msssql instance

1. Use ms SQL Server 2008;
2. The database content is as follows: Zhang San mathematics 98 Li Si mathematics 95 Wang Wu mathematics 90 Zhao Liu English 100 Zhang San English 99 Li Si English 69
3. results to be queried: the first two of each course

The Code is as follows:
Select. xingming,. kemu,. fenshu from xuexi a where. fenshu in (SELECT top 2 fenshu FROM xuexi WHERE xingming =. xingming and kemu =. kemu order by fenshu desc)