AD

Select Top to explain the seven kinds of database to use

Select Top to use a different database usage:
Select Top to use a different database usage:

1. Oracle Database

SELECT * FROM TABLE1 WHERE ROWNUM <= N
2. Infomix database SELECT FIRST N * FROM TABLE1
3. DB2 database SELECT * ROW_NUMBER () OVER (ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM <= N
Or SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY
4. SQL Server database SELECT TOP N * FROM TABLE1
5. Sybase database

SET ROWCOUNT N GO SELECT * FROM TABLE1
6. MySQL database SELECT * FROM TABLE1 LIMIT N
7. FoxPro database SELECT * TOP N FROM TABLE ORDER BY COLUMN
标签: lt, oracle, oracle database, mysql database, sql server database, desc, rownum, db2 database, col1, sybase database, database usage, infomix, foxpro
分类: Database
时间: 2010-11-02

相关文章

  1. Explain the seven database to use Select Top

    Select Top to use a different database usage: Select Top to use a different database usage: 1. Oracle Database ...
  2. Only the first few written seven kinds of data in the database sql statement to use Select Top

    Seven use Select Top in the database methods 1. Oracle Database SELECT * FROM TABLENAME WHERE ROWNUM <= N 2 ...
  3. Select Top in the use of different database usage

    Select Top in the use of different database usage: 1. Oracle Database SELECT * FROM TABLE1 WHERE ROWNUM <= ...
  4. . In Oracle to achieve SELECT TOP N:

    . In Oracle to achieve SELECT TOP N: As the ORACLE does not support the SELECT TOP statement, so in ORACLE is ...
  5. oracle how to achieve a similar statement in MSSQL in Select top N

    Quote MSSQL oracle how to achieve a similar statement in the Select top N to achieve the results drawn from th ...
  6. ORACLE, the methods to achieve SELECT TOP N

    1 in ORACLE ORACLE achieve SELECT TOP N as SELECT TOP statement is not supported, so often used in ORACLE ORDE ...
  7. Select Top to use a different database usage

    Select Top to use a different database usage: 1. Oracle database Select * FROM TABLE1 Where ROWNUM <= N 2. ...
  8. Select Top in the MySQL database to use

    select * from tb_eleclog where uname = 'jimmy' order by time DESC limit 0, 1 Equivalent to select * from tb_el ...
  9. select top @ variable

    select TOP @ PAGE_SIZE * from callsrecords where ctx_id = @ CTX and start_time> = @ START_TIME and start_ti ...
  10. asp中 select top 问题!~

    sql="select top 8 * from Musiclist where "& sql2 &" order by hits desc" 选择前八条无效!~ ...
  11. 七种数据库中Select Top的用法

    Select Top在不同数据库中的使用用法: 1. Oracle数据库 SELECT * FROM TABLE1 WHERE ROWNUM<=N 2. Infomix数据库 SELECT FIRST N * FR ...
  12. Top DBA Shell Scripts for Monitoring the Database

    Basic UNIX Command The following is a list of commonly used Unix command: + ps - Show process + grep - Search ...
  13. top in the unreasonable use of the database

    1. ORACLE SELECT * FROM TABLE1 WHERE ROWNUM <= N 2. INFORMIX SELECT FIRST N * FROM TABLE1 3. DB2 SELECT * R ...
  14. 5 kinds of database sql statement Daquan

    Database sql statement Daquan First, connect the column values db2/oracle/postgresql select name (field) | | ' ...
  15. 5 kinds of database sql statement Encyclopaedia (2)

    24, the value of the table with the other updates db2/mysql update emp e set (e.sal, e.comm) = (select ns.sal, ...
  16. Three kinds of database connection check

    1. The first (no sqlconnection this object) if(conn==null) conn.open() 2. The second (the database is closed) ...
  17. five kinds of database jdbc connection

    package cn.com.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; pu ...
  18. Three kinds of simple and efficient way to test page

    Three kinds of simple and efficient way to test page Posted on 2004-10-02 seventeen past one p.m. squirrel_sc ...
  19. 50 kinds of methods to optimize the SQL Server database queries

    1, there is no index or index is not used (this is the most common query slow problem is programming defects) ...