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 113107

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 9621

Post New Deloitte SQL PLSQL Interview Questions



Un-Answered Questions

please post the interview questions for QA position in FACTSET

3090


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

1304


what happend to DC shunt motor if its field winding insulation becomes slightly weak? will that motor can run on full load or not explain in detail. thanks

395


1)How we can create a master group in segment builder? 2)What are the possible options in post processing of target group? 3)How can u create global target group for product proposal?

1784


WHAT IS THE BANK RECONSILATION, WHAT THE FORMAT OF IT

1001






Why do you want to join software field as you have done your BE in Electronics?

1036


2. In a container filled with each of the following materials, at a porosity of 40%, determine the upward gradient required to cause the quick condition (a) Lead shot with a G = 13.75; (b) Fibre beads with G = 2.15; (c) Sand with a G = 2.32

830


What is Big Data?

37


Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

1044


Give some examples of usage of BW statistics reports?

979


what is tie mechanism in CORBA/Visibroker?

369


hi i went for a walk to hsbc(call center) and i attended to written and telephonic round and next i have to face avp round what type of questions i have to face in that round please sujjest me

2661


why you are opting BPO jobs if you having a degree of MSc?

1412


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

974


how do u manage scripts in winrunner when you application is changing frequently?

681






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)