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

How does ASP.NET framework maps client side events to Server side events.?

1029

What are the different properties of server control that exists?

1071

How you will improve web application performance?

993

How many types of session state management options available in asp.net?

991

What is the concept of view state in asp.net?

975

Which class is used to send an email message from an ASP.NET Web page?

962

can we remote debug applications with the remote debugger installed with vs.net 2002, with vs.net 2003?

2101

What is session object? Describe in detail.

969

Why is string called immutable data type?

995

Differentiate between file-based dependency and key-based dependency.

885

What is viewstate information stored?

1021

What is data binding in asp net?

1045

Explain how does asp page work?

956

What is Web API Routing?

1094

What is the equivalent of date() and time() in asp.net?

943