Follow Our FB Page << >> 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?


How does counta work in excel?


What does apache spark stand for?


What information is defined in the software catalog?


Explain is fact table?


What is meant by binary tree traversal?


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


What is a jsp directive?


What is dom in javascript?


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


Explain the three major types of rocks?


How to install zend on your local machine?


What is faker in laravel?


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.


What is overloading in c#?