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

Which methods validate all the controls on a page?

550

How to unit test Web API?

710

Can you explain the importance of finalize method in .net?

591

Is viewstate enabled by default?

533

What is meant by ispostback in asp net?

544

What are the various types of validation controls provided by asp.net?

540

What is server side session?

522

Explain the difference between codebehind="mycode.aspx.cs" and src="mycode.aspx.cs"?

538

What is an axd file?

594

What is query string with example?

521

What symbol would you use to denote, the start of a code block in aspx views?

573

Define page fragment caching?

528

What is http session state?

523

What is a query string in a url?

539

What is the use of view state?

534