Random records Select in mysql

Question

I have a table name tbl_Employees

id  Name    Designation
1   Rajeev  Developer
2   Deepak  Developer
3   Pankaj  Sales
4   Siksha  Sales
5   Parul   Sales
6   Nikita  HR
7   Dinesh  Account
8   Mahiman Travel
9   Mukesh  Adevertising
10  Pulkit  Marketing
11  Diksha  Database
12  Gurinder    Database

I am using the select query as

select  * from tbl_Employees

Now I am trying to show 5 rows on my .aspx page. now my query is that the 5 rows data is randomly change on every PageLoad event.

possible duplicate of [Select random sampling from sqlserver quickly](http://stackoverflow.com/questions/652064/select-random-sampling-from-sqlserver-quickly) — sameh.q, Sep 01 '14 at 05:06
Because its a sample table and the amount of data is big and from that i have to select only 5 rows randomly :) — Rajeev Mehta, Sep 01 '14 at 05:12
Please refer to this before proceeding : http://msdn.microsoft.com/en-us/library/cc441928.aspx. — SomeUser, Sep 01 '14 at 05:31

score 3 · Accepted Answer · answered Sep 01 '14 at 05:06

3

You can use NEWID() to select records rendomly as below:

SELECT TOP(5) * FROM tbl_Employees ORDER BY NEWID()

answered Sep 01 '14 at 05:06

Pawan

1,704
1
16
37

score 1 · Answer 2 · answered Sep 01 '14 at 05:08

1

select top 5 * from [yourtable] order by newid()

answered Sep 01 '14 at 05:08

Moshtaf

4,833
2
24
34

score 1 · Answer 3 · answered Sep 01 '14 at 05:09

1

select  top(5) * from tbl_Employees order by newid()

answered Sep 01 '14 at 05:09

Genish Parvadia

1,437
3
17
30

i think it's lowercase of your ans, this is very important ;) – Farrokh Sep 01 '14 at 05:15
And i am confused that which ans i used to mark as answer :D – Rajeev Mehta Sep 01 '14 at 05:18

Random records Select in mysql

3 Answers3