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 (285)
  • Deloitte placement papers (3)
  • Deloitte technical test questions (12)



Deloitte SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Differences between UNIQUE and DISTINCT in select statements

26 110351

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 9123

Post New Deloitte SQL PLSQL Interview Questions




Un-Answered Questions

How use Budget in SAP, i want to see the report of variant between budget and actuals.

631


Which thing is maximum in RLC circuit at resonance a)power consumption b)inductive current c)capacitive voltage

342


How the sub ledgers(AP, AR) integrate with GL liability and receivable

673


hi;my name is rahul; im from india;well i have undergraduated student in english studies; then i caried on my studies in social developement departement from which after a year i v got a profesional licence degree in social institutions management; and now im applying for studying mba in usa ( concentration:marketing management)in2008; since 2years up to now im doing trainig in different associations; my sponsor is my uncle.my question is: do i have any chane to get visa in my case; and in ur opinions ladies and gentemlmen what s the most convincing motivations and answered could tell the in embassy? plz don t hesitate to share me ur point of views

854


How to set the number of reducers?

454






how do u calibrate the vacuum transmitter if it shows more reading

759


sir, I am from EEE branch.On feb 17 iam going to write an Exam for hindustan petrolium corporation Ltd.So plz send me the written exam pattern/Q's/interview questions.please mail to eee_dharmendra@yahoo.com

576


HI, FREINDS, I WANT TO KHOW IS THE CFP (CETICFIED FINANCIAL PLANNER) IS A GOOD COURSE, IS THEY ANY INSISTUTE IN HYDERABAD,IF ANY ONE DOING THIS COURSE PLEASE REPLY ME.

799


What are the Short cut Keys of Tally ERP?

872


Thumb rule for steel qty for 1m2 in kg/m2 column slab footing beam

3751


when the time of backcharging the transformer three phases only enough or three phase with neutral is must.from these which one is the best one.

620


How to assign a Null value to a numeric field in a table?

693


Explain the Various types of Mergers at different stages of Industry life cyle? Give some Example of Merger companies.

1561


why copper is a bad conducter at low temperature?

696


why the voltage and current in a long transmission line are called travelling wave?

959






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 (2)
  • JCL (1)
  • DB2 (2)
  • Core Java (1)
  • Servlets (1)
  • Teradata (2)
  • Business Objects (3)
  • Cognos (2)
  • Informatica (20)
  • Data Stage (1)
  • SAS (1)
  • Data Warehouse General (2)
  • HR Questions (1)
  • SAP ABAP (42)
  • SAP SD (23)
  • 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)