select top 20 * from tablename order by newid()

if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?

Question Posted / raj

9 Answers
14763 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / raj

select top 20 * from tablename order by newid()

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which browsers support the xmlhttprequest object?

959

What is viewstategenerator?

1173

What is asp.net mvc5? : Asp.Net MVC

1001

What are session and cookies?

935

Explain the path instructions in xaml?

958

What is Razor View Engine

1037

How to unit test Web API?

1174

Which is the parent class of the ASP.NET server control?

1034

Why we are using mvc instead of asp.net? : Asp.Net MVC

991

Can you set which type of comparison you want to perform by the comparevalidator control?

881

Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

2110

What are the types of authentication in asp.net?

978

What is the purpose of App_Code folder in ASP.NET? Why we this?

1212

What type of code, client-side or server-side, is found in a code-behind file of a Web page?

919

How about the security in Activex DLL and Activex EXE ?

2244