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 |
How can you quickly find out the number of rows updated after an update statement?
How many databases can be created inside an instance in db2 ?
What is the role of data manager in the db2 database?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is a base table?
What parameters are used to control the free space in DB2?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What are column-name qualifiers used?
what is load and unload in db2
What are the contents of dclgen?