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
9634 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

What does trigger mean in psychology?

1008

How delete all data from all tables in sql?

983

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1007

Can you have a foreign key without a primary key?

997

what are the different index configurations a table can have? : Sql dba

1039

What are operators available in sql?

1095

Is sql similar to python?

1033

What is trigger and types?

1068

what is the functionality of the function htmlentities? : Sql dba

1005

What are synonyms in sql?

1018

Is not null in sql?

1042

What is the location of pre_defined_functions.

1208

What is trigger types of trigger?

1140

How do I run a pl sql procedure in sql developer?

1020

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1277