if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records
- 4 Answers
- 6611 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / viji
If there is any specific order they have to be fetched then use fetch first 3 records only.
Without order by, fetch first 3 records only will retrieve any 3 records in random order.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
can all users have the privilage to use the sql statement select * (dml)?
How is deadlock resolved?
What is a db2 tablespace?
Which components manage deadlocks in db2?
What is dbrm?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Which command is used to remove all rows from a table?
what is the sqlcode -501
List down the types of triggers in the db2 database?
define clustering index.
What is runstats and reorg in db2?
When the like statement is used?
How many databases can be created inside an instance in db2 ?
How do I start db2 in windows?
