Dev Corner

Software Developer’s Notepad

Select Random Row in Microsoft SQL Server (MSSQL)

baobab under Database

Here is a SQL query that selects a random row from a Microsoft SQL Server table.

SELECT TOP 1 first_name, last_name FROM customer ORDER BY NEWID()
« Select Random Record in MySQL
Select Random Row form IBM DB2 Table »

Add A Comment

You must be logged in to post a comment.

Subscribe to Dev Corner