Difference between Top and Limit Keyword in SQL

by

If you are using SQL Server use TOP if you are using MySQL or Postgres use Limit!

AFAIK there is no product that currently supports both. Here’s one list of current implementations and here’s another (covers more products but in less detail)

More Related Contents:

  1. Max sal to print base on manager_id
  2. Join vs. sub-query
  3. Refactor a PL/pgSQL function to return the output of various SELECT queries
  4. sql server 2008 management studio not checking the syntax of my query
  5. Subqueries vs joins
  6. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  7. Select count(*) from multiple tables
  8. SQL UPDATE SET one column to be equal to a value in a related table referenced by a different column?
  9. How to run a SQL query on an Excel table?
  10. conditional unique constraint
  11. SQL: Find the max record per group [duplicate]
  12. REGEX to select nth value from a list, allowing for nulls
  13. Natural join in SQL Server
  14. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  15. Pivot using SQL Server 2000
  16. MySQL: What is a reverse version of LIKE?
  17. Select only rows by join tables max value
  18. Using Excel VBA to run SQL query
  19. WHERE IN condition not accepting String value
  20. MySQL select where column is not empty
  21. The backend version is not supported to design database diagrams or tables
  22. Postgres – Function to return the intersection of 2 ARRAYs?
  23. Split string and take last element
  24. Can I set ignore_dup_key on for a primary key?
  25. How do I add a auto_increment primary key in SQL Server database?
  26. BigQuery SQL for 28-day sliding window aggregate (without writing 28 lines of SQL)
  27. Convert String to Date in MS Access Query
  28. Update multiple rows with one query?
  29. Convert bigint to datetime
  30. Drop column from SQLite table

Leave a Comment