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
9412 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 is compute?

1010

what is a cursor? : Sql dba

972

How many types of keys are there in sql?

985

What is sql and how does it work?

1086

What is cursor and its types?

994

Is sql developer case sensitive?

943

How do you delete data from a table?

973

What is sql resultset?

931

What is rownum?

923

Does sql between include endpoints?

951

what is a database lock ? : Sql dba

1092

Can we use update in sql function?

1005

What happens when a trigger is associated to a view?

839

Does truncate release storage space?

1013

How much ram can sql express use?

928