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 113813

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 9777

Post New Deloitte SQL PLSQL Interview Questions



Un-Answered Questions

how  do you choose the cable size as per amps rating & the voltage drop for the same.

683


why we permissive overreach in distance protection.where it is applicable to use in long r short lines

1521


can one defect be mapped to more than one test script in manual testing

1149


write a program for the normal snake games find in most of the mobiles.

1181


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2112






any book or article on pumped concrete.

929


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

805


Expand---------DBPC

875


What application areas are you comfortable in?

192


Which steps do you take to overcome a prospect's sales resistance?

1222


Excise Duty Applicable for Assembly Materials E.g: I.T Products (Security Systems)

1546


what i would like to contribute to bhel,s growth

1635


Why we make body earthing of transformer and what will be the size of the copper wire for this purpose related to KVA Capacity of the Transformer as per code.

242


how impurity is analyzed in a tablet

2001


why you are join as a quality analyist ?

1010






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)