Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 135669

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 14867

Post New Deloitte SQL PLSQL Interview Questions


Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

Why do we need sparkcontext?

297


What is cognos powerhouse?

1026


What is the implementation of applicationcontext container?

463


What is bootstrapping in angular?

858


Explain what do you know about blackberry 7?

902


Hi Mr.Anil even i am looking for the same to start up a call center did u come to know the details if u plese let me alo know.my mail id is madhueric11@gmail.com

2127


What is ip spoofing and how can it be prevented?

942


How do you create surrogate key using ab initio?

996


Explain the concept of otr(online text repository) and its usage?

312


What is hot deployment in tomcat?

857


What is e-commerce tracking in google analytics?

137


What is Inductive Logic Programming in Machine Learning?

134


How long does it take you to process one day's worth of patient visits or claims? : insurance health

600


What is arc ios?

839


What is hipot test procedure?

1462