Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 11185

Post New Ness Technologies SQL PLSQL Interview Questions




Ness Technologies SQL PLSQL Interview Questions


Un-Answered Questions

Write the full form MANOVA and why is it used?

24


How to Create a Worker Thread for Background Processing ?

1058


How we get sum of column.

201


How do I enable activex?

154


What does ctrl y do in photoshop?

132






Can I build a good future in "IT profile(non-BPO)" by joining as Technical support voice at IBM/ Wipro/Dell .....??? Please do guide me in this case...

1304


What are bean wiring and @autowired annotation?

38


How dashboard is created in sap bw?

226


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4573


What are launch modes?

202


What desktop does ubuntu 18.04 use?

162


What are the advantages and disadvantages of public-key cryptography over secret-key cryptography?

219


The way to show high five and last five sales in the same view?

92


Give some ways by which you can define the variables to produce the summary report (using proc report)?

255


what is hash files in sas and why we are using this one in sas?

1357