Answer Posted / asp
select * from table1 a where (n-1) = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What is a db2 tablespace?
Mention the downsides of page level lock.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What are host variables in db2?
define clustering index.
Explain the function of data manager.
How many databases are there?
What is a db2 cursor?
What is db2 look?
How would you find out the total number of rows in a db2 table?
What is check constraint. Explain with example.
What do you mean by cursor?
Explain dclgen.
How can you count the number of rows from a table tab?
Is db2 free?