how will you retrieve first record in table
Answer / saravana
select empname,empno from tablename order by empno fetch
first row only;
Is This Answer Correct ? | 11 Yes | 0 No |
What is copy pending and check pending in db2?
wht is d/f between union and joins ?
What is iseries database?
How many sub queries can you combine together ?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is nvl in db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is runstats db2?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How to find the maximum value in a column in the db2 database?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is explain in db2?