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 127289

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 12952

Post New Deloitte SQL PLSQL Interview Questions


Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

Explain access specifiers?

620


What is the function of pure virtual functions?

498


In how many ways can a CSS be integrated as a web page?

424


how much one carpenter can doing shuttering of slab in one day

2851


Explain stream in node.js along with its various types.

221






What is the use of $_server and $_env?

539


What is SMTP (Simple Mail Transfer Protocol) ?

1424


how will you find a particular line in debugging if its a infinite loop

1314


Do you know what is similarity and difference between truncate and delete in sql?

544


Is not equal in sql?

538


Which variables are stored in heap?

514


How will iot benefit the end-users?

1


Does it cover silver or golden ornaments if I have Home insurance?

414


List the area of applications of data structure.

730


Explain the role of assembly in the .net framework.

541