Answer Posted / bhaskar reddy
select * from table1 a where(n-1)= (select count(distinct
sal) from table1 b where b.sal>a.sal)
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What are db2 objects?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Mention the various locks that are available in db2.
When the like statement is used?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
what is diffrence b/w file-aid tool and file-aid utility???
What is the syntax for seeing the columns and data types of a table in the db2 database?
List out the buffer pools in db2
What is sqlca?
What are concurrency issues?
What is access path in db2?
Explain package in db2 and its advantages?
How can we read records for specific member in CL? AND rpg?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?