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 121545

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 11244

Post New Deloitte SQL PLSQL Interview Questions




Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

Explain what are the functions of the typical server program? : Client server computing

215


what is isolation level at dead lock?

1398


Hi, my interview is scheduled for IBM.can any on send sap crm faqs.my id is siri.testing@gmail.com.thanks in advance. siri

2177


Which operator can be used to check if two numbers are equal or not in vbscript?

266


How is arsenic produced?

269






What are the advantages of sql?

218


What are java methods?

214


Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

2297


What is soil classification? : soil science

269


Which is best ide for java?

208


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

338


What are pre-processor & post-processor elements?

111


What is an assembly in .net?

225


From selenium ide how you can execute a single line?

392


What are the types of mapping?

1