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
How to install oracle sql developer?
How does cross join work in sql?
How do I save a stored procedure?
Name the operator which is used in the query for pattern matching?
what is a trigger in mysql? : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
What is a constraint? Tell me about its various levels.
Can we use ddl statements in stored procedure sql server?
Explain polymorphism in pl/sql.
What will you get by the cursor attribute sql%found?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is sqlcommand?
What is trigger in sql and its types?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is clause?