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?

228


What does EIB mean in CICS?

659


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

1527


Why does my monitor keep blinking?

436


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

1805






What are the parts of Bank's capital?

652


Explain the marketing calendar?

5


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

286


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

485


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

1538


How do I know if chkdsk is running?

419


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

4707


How we can use vlookup in excel with example?

262


How do we add javascript onto a web page?

476


are you willing to work nights and weekends?

589