Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8042 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / gummadi
select * from table_name
order by ascending
fetch first 3 rows only
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the bind parameters ibm db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
is it compulsory commitment control in journal?
How would you find out the total number of rows in a db2 table?
How can the duplicate values be eliminated from db2 select?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is load utility in db2?
What is null indicator in cobol db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do I add a column to an existing table in db2?
What db2 400?
How will you return the number of records in table?
What is package in cobol db2?
What are the full forms of spufi and dclgen and why are they used?
What is the difference between oracle and db2?
