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

Deloitte SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Differences between UNIQUE and DISTINCT in select statements

26 127200

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 12917

Post New Deloitte SQL PLSQL Interview Questions

Deloitte SQL PLSQL Interview Questions

Un-Answered Questions

Where you can deploy node application?


What does EIB mean in CICS?


what question do you think is important question you have been ask?


Why does my monitor keep blinking?


i have done B.TECH in doing MBA . why you doing mba why u have not join any job.


What are the parts of Bank's capital?


Explain the marketing calendar?


What are different recovery mechanism can be performed in hana system?


You are a project manager and are in the Closing process of the project. Your customer has been presented with a formal acceptance and sign-off document. They refuse to sign, claiming the product does not meet their expectations. You know that this situation could have been prevented by doing all of the following except : A. Documenting the requirements B. Documenting the customer's refusal to sign C. Performing quality inspections during the process D. Requesting sign-off at important milestones


how does a shunt reactor maintains the bus voltage???


How do I know if chkdsk is running?


what is the difference b/w UHVDC and HVDC(LIGHT)?


How we can use vlookup in excel with example?


How do we add javascript onto a web page?


are you willing to work nights and weekends?