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 aptitute test questions (4)
  • Deloitte interview questions (289)
  • Deloitte placement papers (3)
  • Deloitte technical test questions (13)



Deloitte SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Differences between UNIQUE and DISTINCT in select statements

26 112157

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 9427

Post New Deloitte SQL PLSQL Interview Questions



Un-Answered Questions

Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

745


What are the generally asked questions for a Person who is attending Network protocol testing L2/L3.

2985


please can any one tell me clearly about pid tuning i am confusing about this .how to tune pid easly?

867


types and working of compressor

1441


why ,in CE configuration amp the output is 180 deg phase shift....?

1496






I am a general practitioner and i want to ask about a case:a 10 year old boy with numerous monomorph(vesicular) acne in the face,it is his third eruption in the last year,with out any other diseases or sign and symptom exept for :his weight:56kg with truncal obesity height:153cm ,how can I approach it?is there any risk of precautious puberty while there is no manifestation of pubertal signs? bye the way his nutritional status and history seems to be good.

1369


hi,when i am posting an entry on service tax it is not showing the business area.please guide me how to configure the business area so that the entry also shows the business area.please help as i need to configure it.

863


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

858


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1121


Merits & Demarits of Oil circuit & Air circuit breakers ?

840


Where mixed flow type compressors are used?

548


How is Telon(CA-Telon) used to build map?

2317


it is possible to rotate the DG engine dc starter with wrong polarity connections? why?

958


help me with the question that might be ask on the interview for technical position

986


What will happen if boiler backfires?

696






Deloitte SQL PLSQL Interview Questions
  • Programming Languages AllOther (2)
  • ASP.NET (3)
  • Dot Net Framework (1)
  • Dot Net General (14)
  • Microsoft Related AllOther (1)
  • SQL Server (1)
  • SQL PLSQL (2)
  • Unix Commands (1)
  • QTP (11)
  • Manual Testing (11)
  • Mobile Testing (1)
  • Test Cases (1)
  • Testing AllOther (1)
  • COBOL (3)
  • JCL (1)
  • DB2 (2)
  • Core Java (1)
  • Servlets (1)
  • Teradata (2)
  • Business Objects (3)
  • Cognos (2)
  • Informatica (21)
  • Data Stage (1)
  • SAS (1)
  • Data Warehouse General (2)
  • HR Questions (1)
  • SAP ABAP (44)
  • SAP SD (24)
  • SAP PP (3)
  • SAP FI CO (11)
  • SAP Business Warehouse (1)
  • SAP Security (4)
  • SAP B1 (1)
  • Siebel (1)
  • Oracle Apps Technical (5)
  • Oracle Apps Financial (28)
  • Oracle Apps SCM (2)
  • Bio Informatics (1)
  • Mechanical Engineering (2)
  • Business Administration (1)
  • Banking Finance (5)
  • Human Resources (9)
  • Audit (6)
  • Taxation (7)
  • Accounting General (10)
  • Accounting AllOther (33)
  • Call Centre AllOther (3)
  • General Knowledge_Current Affairs (1)
  • Everything Else AllOther (6)
  • General Aptitude (5)
  • Placement Papers (3)
  • CISA Certification (1)
  • MAT (1)