How to get Top 10 Salaries from a Table
Answer Posted / abirami
Sorry.. Answer 1 given by me is incorrect.
Correct Query is
select disntinct salary from tablename
Order by salary
Fetch first 10 rows only
Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
What types of tables are there in the db2 database?
What is copy pending and check pending in db2?
what is a corelated subquerry?
Mention data types used in db2 ?
What is the difference between nvl and coalesce?
Explain about rct.
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are concurrency issues?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Name the various locking levels available?
What is dbrm? When it will be created?
List out the data types available.
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?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is ibm db2 used for?