If you are a PHP or Java Developer you should be familiar with MySQL database right?
Table name: employee
|1||Agurchand||Software Engineer||2013-01-07 11:47:10|
|2||Babu||Software Engineer||2013-01-02 01:06:00|
|3||Abhiesheik||Broadcast Engineer||2013-01-10 18:04:02|
|4||Juki||Content Writer||2012-12-27 06:16:32|
|5||Aparna||Social Executive||2013-01-27 03:47:00|
|6||Arun||Sofware Engineer||2012-12-27 08:12:10|
If we need to get random 3 records from the above table in MySQL the query will be like this:
SELECT * FROM employee ORDER BY RAND() LIMIT 3
But, in MS SQL we cannot use ‘LIMIT’ and ‘RAND()’ instead we are allowed to use ‘TOP’ and ‘NEWID()’
So, the MS SQL query will be like this:
SELECT TOP 3 * FROM employee ORDER BY NEWID()
I hope this would have helped you today!