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 119162

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 10673

Post New Deloitte SQL PLSQL Interview Questions




Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

Is mysql open source?

81

How do I create a variable number of variables?

109

How to add custom php codes in my drupal pages or blocks?

12

Can I delete program files x86?

96

What does hibernate.hbm2ddl.auto create means?

1




What is the difference between b and br tag?

86

How do you add a copyright symbol on a html page?

98

What is the difference between the ‘font’ and ‘fontmetrics’ class?

125

Explain more functions in brief in r?

4

In the short range what will happen to the levels above and below a population of secondary consumers of a numeric pyramid if a large number of individuals from this population dies?

13

Is it possible to calculate depreciation to the day?

142

Will you be successful if you continue working in this field?

188

What is the engine rating required for 1000 KVA Generator set. Calculations?

1396

What is an rss email?

99

What is decode in static cache?

135