Sometimes you need to return a limited number of rows such as selecting the first 10 rows of some table, web will show how to do this using MySQL, Sql Server and Oracle

Selecting random records in SQL Server

Selecting random records in SQL Server, some times you need to get random rows from some table with SQL Server, to do it you have to use the following SQL Server query