Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Ness Technologies SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 10593

Post New Ness Technologies SQL PLSQL Interview Questions




Ness Technologies SQL PLSQL Interview Questions


Un-Answered Questions

1.WHAT IS A SMART CAPABLE DB ( DISTRIBUTION BOX) ? 2. HOW TO DECIDE THE TYPE OF DB TO BE USED ( RECESSED/ PLUG TYPE/ SMART ETC ETC? 3. WHAT IS MILLENEUM BUS BAR USED IN DB? 4.DIFFERENTIATE MCCB AND MCB.

900


What is the use of paging in operating system?

105


why are measure gas flow " ml " in Gas chromatography

641


Explain what is valet?

71


How can you navigate to see the error idocs?

90






Why actionservlet is singleton in struts?

137


Name the different types of checkpoints?

87


What is python shell scripting?

67


which osi layer consists of characteristics like acknowledgement, flow control and sequencing?

106


What is slt?

11


How do you bold a cell in excel?

5


Can I use the same windows 10 key on two computers?

80


What is unicode full form?

69


What are pre-processor elements? List some of the elements.

18


what are the different types of fact structures?

100