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 117460

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 10410

Post New Deloitte SQL PLSQL Interview Questions




Deloitte SQL PLSQL Interview Questions





Un-Answered Questions

Can you please explain the difference between namespace and assembly?

41


what is castigliano theaorem

1239


which connection is safer series or parallel?usually which connection we prefer at home?

5935


what's the difference between impress cash account and petty cash account

463


when are objects are passed from task to the change request?

1092






What is the client concept in SAP? What is the meaning of client independent ?

981


sir, pls mail me the previous question papers of RRB Junior Engineer Gr-II Drawing

890


What are the benefits of linux?

40


Explain how to import lovs?

40


Can constant snackings are harmful for teeths?

68


What is a block in blockchain?

1


What all rounds do we have to face in dell(bpo)??

780


What is the opposite of concatenate in excel?

1


what is capitalization? What is its importance?

74


Give list of building construction equipment & explain about them in brief. How much is output of JCB, POCLAIN, Steel cutting & bending machine, material hoist, tower crane?

1980