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 112782

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 9540

Post New Deloitte SQL PLSQL Interview Questions



Un-Answered Questions

If you were given a chance to talk to the president what would you like to ask and why?

544


explain construction of lvdt?

978


Why we have to add 200mg Na2CO3 in preparation of 0.1N sodium thiosulfate solution?

174


Please is there any one working with ITR.COM? Having interview with them. Any tips will help.

528


Difference between different strategy groups.

355






which cultures or subcultures or standards are generally using as a positive control for total aerobic microbial count in API?

862


When looking at a flanged extension pipe and it is labeled DN20, just what does that mean or intel?

1130


69,70 or 71 in box-1 ; 18,19, or 20 in box-2 ; 60,61, or 62 in box-3 get -3 , -4 , or -5 in box-2 in 3 steps.Use all operations i.e. ( +,-,*,/ ).

1044


HOW TO CONVINCE CUSTOMER IN INSURANCE BPO JOB?

3421


how is work pressure switch& level switch?what is the principle of this?

1318


how do u really know that paging to disk is happening while u are using a lookup transform?

767


The efficiency of a pin fin with insulated tip is

159


What makes you better than the other people I'm seeing today?

2132


How we create SQL Server 2005 Reporting Services ? Give me Sample

919


Is Genetic Engineering worth the cost and effort?

1535






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)