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 117127

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 10350

Post New Deloitte SQL PLSQL Interview Questions




Deloitte SQL PLSQL Interview Questions





Un-Answered Questions

Explain Features of WordPress?

7

How to use earthing on shipments.

289

What is Standard observer?

492

How many categories of data types in oracle?

41

what are the differences among rownum, rank and dense_rank? : Sql dba

42




Give me At Least 5 Differences between DOCUMENTATION OBJECT MODEL(DOM)and COMPONENT OBJECT MODEL(COM)? Interviewer said me to WRITE the difference only in points not as you WRITE a paragraph ???? only in points

1025

Procedure to push the app in appstore?

45

Give an example where you need jsp custom tag?

37

What is Relationship set?

32

Can one drop a column from a table?

45

What is unix operating system?

21

Explain first() operation in Apache Spark RDD?

28

How many people have left in the last year?

80

What is called cognos reporting tool?

59

This process applies evaluation criteria to the bids and proposals received from potential vendors: A. Solicitation B. Contract Administration C. Source Selection D. Quality Assurance

59