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 }
Answer Posted / padma
select top 100 * from <tablename>
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Why is nosql good?
How to start oracle sql developer?
What is view? Can we update view
What is anonymous block in sql?
How many types of normalization are there?
what are the advantages a stored procedure? : Sql dba
Why indexing is needed?
How to avoid using cursors?
what is “go” in t-sql? : Transact sql
how to delete an existing column in a table? : Sql dba
What is a Mapplet?
what is difference between delete and truncate commands? : Sql dba
Why use triggers in sql?
Is primary key always clustered index?
what is a control file ? : Sql dba