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 118182

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 10550

Post New Deloitte SQL PLSQL Interview Questions




Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

How do I sort two columns in excel to match?

1


What are the different types of protocols?

1


what does the automatic recovery do? : Sql server administration

88


what is hvac?

1593


What is glossary of software qa/testing?

61






Will I need to have an account with a wi-fi service provider?

64


what is the use of defining cloud architecture?

1


What exactly does one comprehend the security of a block?

1


How to see the inductance in a transmission lines

1105


Does wordpress run on php 7?

70


If a person drawing RS.29000/- as net salary per month... Can any one please provide is his gross salary and total other cuttings...

1366


This perceived force, that seems to want to throw a person off a merry-go-round, is often regarded by physicists as a fictitious force:

78


How to check the already installed dependencies which are globally installed using npm?

14


What are the different types of modules in oracle forms?

90


What is format function?

1