This example shows the MS-SQL (Microsoft SQL-Server) counterpiece for the limit command of MySQL.
Nis 122010
There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don’t require additional application logic, but each database server requires different SQL syntax.
Select a random row with MySQL:
SELECT column FROM table
ORDER BY RAND()
LIMIT 1
Devamını okuyun »