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

Difference between .NET and previous version?

2591

Explain difference between friend and protected friend?

931

What is the use of autowireup in asp.net?

1057

What is the difference between asp.net and mvc?

1120

What are uri parameters?

1042

What is the use of view state?

947

What is slidemaster?

939

Why do we use datasource in asp.net?

974

In which situation can you not use a viewstate?

965

What is the difference between cache and cookies?

1025

Is post back property in asp net?

1029

Explain how do you validate the controls in an asp .net page?

932

If you are using two select queries and retrieving data. how do you access second query's result set using data reader?

5590

What are the components of ado.net?

959

Where the assembly is stored in asp.net?

1014