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

Answer Posted / raj

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are the advantages and disadvantages of Using Cookies?

979

How do you implement sql caching in asp.net?

1071

Explain cashing in asp.net.

1000

Is asp.net free?

1005

What is application variable?

954

Define web services in asp.net.

1072

code for "For every 5days system has to create 1text file with the corresponding date and it has to store in c-drive" by using web applications

1864

Which property is used to identify the Page is Post Back in ASP.NET?

1024

How many languages are supported by .NET at present time?

788

Which method is used to perform all validation at the page level?

976

Explain how to prepare culture-specific formatting in .net.

980

How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server

6653

What are the different types of validation controls provided in ASP.NET?

1168

what is silver light when will we use silver light,

1915

What is http post and http get?

1024