select top 100 * from <tablename>

How do you retrieve set of records from database server.

{Set max records = 100 & use paging where pager page no or
records = 10 & after displaying 100 records again connect to
database retrieve next 100 }

Question Posted / padma

2 Answers
9536 Views
DELL, I also Faced
E-Mail Answers

Answer Posted / padma

select top 100 * from <tablename>

Is This Answer Correct ?

0 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is mariadb nosql?

1041

What is the least restrictive isolation level? : Transact sql

1065

What is cursor explain with example?

984

What is hibernate and its relation to sql?

1123

How do you update a value in sql?

1043

how to shutdown mysql server? : Sql dba

1100

what's the difference between a primary key and a unique key? : Sql dba

1049

Does sql require a server?

1011

What is relationship? How many types of relationship are there?

1181

What is a schema sql?

1152

what are the different type of sql's statements ? : Sql dba

924

Is microsoft sql free?

1100

Explain normalization and what are the advantages of it?

953

how to use myisamchk to check or repair myisam tables? : Sql dba

970

How do I find sql profiler?

939