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
- 8231 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
How to execute stored procedures?
What is the physical storage length of time data type?
Which component is responsible for db2 startup and shutdown?
What is runstats and reorg in db2?
What is a page in db2?
How to find primary key of a table in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
When the like statement is used?
What is the difference between plan and package in db2?
Define db2 and its databases?
What does db2 blu stand for?
What is dbrm? What it contains?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do I add a column in db2?
