Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 124275

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 11989

Post New Deloitte SQL PLSQL Interview Questions


Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

How to define routes using Express?

105


How does counta work in excel?

164


What does apache spark stand for?

120


What information is defined in the software catalog?

3


Explain is fact table?

341






What is meant by binary tree traversal?

381


what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply

1506


What is a jsp directive?

289


What is dom in javascript?

341


How to display nth highest salary from a table in a mysql query?

358


Explain the three major types of rocks?

267


How to install zend on your local machine?

91


What is faker in laravel?

286


write a program to convert a expression in polish notation(postfix) to inline(normal) something like make 723+* (2+3) x 7 (not sure) just check out its mainly printing expression in postfix form to infix.

3245


What is overloading in c#?

308