select * from table name where rownum <= 20;

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

Question Posted / irfan

Answer Posted / irfan

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does asp.net still recognize the global.asa file?

1020

What is asp.net master page?

932

How ASP.NET page works?

1052

How to implement role based security in asp.net mvc? : Asp.Net MVC

975

Explain how is a property designated as read-only?

960

What is localhost in asp.net?

966

Define resource files.

917

Explain different types of Caching techniques in ASP.NET?

956

What are httphandlers and httpmodules and difference between them?

953

Can you change a Master Page dynamically at runtime?

924

What are the differences between code behind and code inline?

1010

How may clustered index we can create in table?

963

Is post back property in asp net?

974

Explain culture and uiculture values.

932

In which event of the page viewstate is available?

827