SQL - Select first 10 rows only

Question

How do I select only the first 10 results of a query   I would like to display only the first 10 results from the following query   SELECT a names           COUNT b post title  AS num     FROM wp celebnames a     JOIN wp posts b ON INSTR b post title  a names   gt  0     WHERE b post date  gt  DATE SUB CURDATE    INTERVAL 1 DAY  GROUP BY a names ORDER BY num DESC

User · Answer

Depends on your RDBMS  MS SQL Server  SELECT TOP 10       MySQL  SELECT     LIMIT 10   Sybase  SET ROWCOUNT 10 SELECT       Etc

User · Answer

What you re looking for is a LIMIT clause   SELECT a names           COUNT b post title  AS num     FROM wp celebnames a     JOIN wp posts b ON INSTR b post title  a names   gt  0     WHERE b post date  gt  DATE SUB CURDATE    INTERVAL 1 DAY  GROUP BY a names ORDER BY num DESC    LIMIT 10

User · Answer

PostgreSQL   SELECT     LIMIT  num  OFFSET  num

User · Answer

In SQL server  use   select top 10       e g    select top 100   from myTable select top 100 colA  colB from myTable   In MySQL  use   select     order by num desc limit 10

User · Answer

Firebird   SELECT FIRST 10   FROM MYTABLE

User · Answer

Oracle  WHERE ROWNUM  lt   10  and whatever else     ROWNUM is a magic variable which contains each row s sequence number 1  n

User · Answer

The ANSI SQL answer is FETCH FIRST   SELECT a names           COUNT b post title  AS num     FROM wp celebnames a     JOIN wp posts b ON INSTR b post title  a names   gt  0     WHERE b post date  gt  DATE SUB CURDATE    INTERVAL 1 DAY  GROUP BY a names ORDER BY num DESC FETCH FIRST 10 ROWS ONLY   If you want ties to be included  do FETCH FIRST 10 ROWS WITH TIES instead   To skip a specified number of rows  use OFFSET  e g       ORDER BY num DESC OFFSET 20 FETCH FIRST 10 ROWS ONLY   Will skip the first 20 rows  and then fetch 10 rows   Supported by newer versions of Oracle  PostgreSQL  MS SQL Server  Mimer SQL and DB2 etc

User · Answer

SELECT  Top 12  Month  Year  Code FROM TempEmp  ORDER BY  Year DESC month DESC

User · Answer

SELECT  from  lt table name gt  WHERE rownum  lt   10

User · Answer

In standard SQL you can use       FETCH FIRST 10 ROWS ONLY  This is supported in DB2  PostgreSQL and Oracle 12 1  and later

User · Answer

SELECT       FROM  SELECT ROW NUMBER    OVER  ORDER BY user id  user row no  a   FROM temp emp a     WHERE user row no  gt  1 and user row no  lt 11     This worked for me If i may i have few useful dbscripts that you can have look at  Useful Dbscripts

User · Answer

In MySQL   SELECT   FROM  table  LIMIT 0  10

[sql] SQL - Select first 10 rows only?

Examples related to sql