ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  MainFrame  >>  IBM MainFrame  >>  DB2
 
 


 

 
 COBOL interview questions  COBOL Interview Questions
 JCL interview questions  JCL Interview Questions
 CICS interview questions  CICS Interview Questions
 DB2 interview questions  DB2 Interview Questions
 IMS interview questions  IMS Interview Questions
 IDMS interview questions  IDMS Interview Questions
 Natural interview questions  Natural Interview Questions
 ADABAS interview questions  ADABAS Interview Questions
 REXX interview questions  REXX Interview Questions
 Assembler interview questions  Assembler Interview Questions
 CLIST interview questions  CLIST Interview Questions
 QMF interview questions  QMF Interview Questions
 MVS interview questions  MVS Interview Questions
 OS390 interview questions  OS390 Interview Questions
 OS 2 interview questions  OS 2 Interview Questions
 VSAM interview questions  VSAM Interview Questions
 QSAM interview questions  QSAM Interview Questions
 Sysplex interview questions  Sysplex Interview Questions
 IBM MainFrame AllOther interview questions  IBM MainFrame AllOther Interview Questions
Question
How to get Top 10 Salaries from a Table
 Question Submitted By :: Suresh66
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to get Top 10 Salaries from a Table
Answer
# 1
select max(salary) from tablename
fetch first 10 rows only
 
Is This Answer Correct ?    3 Yes 14 No
Abirami
 
  Re: How to get Top 10 Salaries from a Table
Answer
# 2
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 ?    8 Yes 6 No
Abirami
 
 
 
  Re: How to get Top 10 Salaries from a Table
Answer
# 3
select top 10 salary from table name order by salary;
 
Is This Answer Correct ?    1 Yes 9 No
Samsunisa
 
  Re: How to get Top 10 Salaries from a Table
Answer
# 4
The query will be like this:

Select distinct salary from table
order by salary desc
fetch first 10 rows only
 
Is This Answer Correct ?    7 Yes 3 No
Meena Dogra
 
  Re: How to get Top 10 Salaries from a Table
Answer
# 5
select distinct  salary from table name hwre rownum <=10
 
Is This Answer Correct ?    1 Yes 0 No
Regu
 

 
 
 
Other DB2 Interview Questions
 
  Question Asked @ Answers
 
What is a DB2 plan?  4
When can an insert of a new primary key value threaten referential integrity?  2
How to resolve -805 error in DB2? Cap-Gemini1
Where is the access path logic created by the DB2 Optimizer stored?  1
What is DCLGEN ?  2
What is a subselect? Is it different from a nested select?  1
What will the FREE command do to a plan?  1
What is a buffer pool?  2
Normalization in DB2 – first normal form, second normal form Virtusa4
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?  2
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?  2
What is a result table?  1
What is the picture clause of the null indicator variable?  5
what is REORG? what is the use?  3
What is a view? Why use it?  1
what types of copies can be made with the COPY Utility ?  1
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008? Perot-Systems5
What is dynamic SQL?  1
The only place of VSAM KSDS in DB2 is?  2
What is meant by a unit of recovery?  1
 
For more DB2 Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com