SQL – Select first 10 rows only?

by

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

More Related Contents:

  1. query sql between two tables [duplicate]
  2. How does database indexing work? [closed]
  3. SQL Server – Best way to get identity of inserted row?
  4. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  5. Concatenate columns in Apache Spark DataFrame
  6. How to pass parameters to query?
  7. Passing multiple values for a single parameter in Reporting Services
  8. Fetch the row which has the Max value for a column
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  11. SQL: find missing IDs in a table
  12. Pass table as parameter into sql server UDF
  13. SQL to generate a list of numbers from 1 to 100
  14. SQL WHERE ID IN (id1, id2, …, idn)
  15. Aggregate function in SQL WHERE-Clause
  16. Fastest way to determine if record exists
  17. Group by date only on a Datetime column
  18. Error message: (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.)
  19. SQL – Query to get server’s IP address
  20. I keep getting the error “relation [TABLE] does not exist”
  21. How to concatenate many rows with same id in sql?
  22. Regular expression to match common SQL syntax?
  23. SQL server join tables and pivot
  24. SQL: How do you select only groups that do not contain a certain value?
  25. How do I compare 2 rows from the same table (SQL Server)?
  26. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  27. Backup a single table with its data from a database in sql server 2008
  28. How to use SQL LIKE condition with multiple values in PostgreSQL?
  29. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment