Answer: We can use
NewID() in-built Sql Server function to fetch Random Rows.We have to give it after Order by clause,then it will populate random rows each time query is hit.
For Example:-
select * from employee_master order by newid();
Asked In: Many Interviews |
Alert Moderator