How to write a (MySQL) “LIMIT” in SQL Server?

by

LIMIT does not work in T-SQL. Use TOP instead:

SELECT TOP(1) * FROM tableEating WHERE person = '$identity';

As Aaron says, you also need an ORDER BY if you don’t want to get an arbitrary row.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  5. Storing JSON in database vs. having a new column for each key
  6. MySQL LIMIT clause equivalent for SQL SERVER
  7. SQL: Repeat a result row multiple times, and number the rows
  8. How to export SQL Server database to MySQL? [duplicate]
  9. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  10. How to transform a MSSQL CTE query to MySQL?
  11. Is there a Profiler equivalent for MySql? [closed]
  12. Why do results from a SQL query not come back in the order I expect?
  13. When to use SELECT … FOR UPDATE?
  14. Best practices for SQL varchar column length [closed]
  15. Relationship between catalog, schema, user, and database instance
  16. Import MySQL database into a SQL Server
  17. How to export data from SQL Server 2005 to MySQL [closed]
  18. What resources exist for Database performance-tuning? [closed]
  19. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  20. How to migrate SQL Server database to MySQL? [closed]
  21. how to cast the hexadecimal to varchar(datetime)?
  22. sql group by versus distinct
  23. How to import a SQL Server .bak file into MySQL?
  24. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  25. Equivalent of MSSQL IDENTITY Column in MySQL
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment