Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Differences between UNIQUE and DISTINCT in select statements

26 132509

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 14139

Post New Deloitte SQL PLSQL Interview Questions


Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

what is 'mysqld'? : Sql dba

804


Some of the functions that we want our macros to accomplish are not possible without first unprotecting the worksheet/workbook with the password?

454


What is the shortcut for clear formatting?

505


What is volatile data type?

814


What are the problems which are being faced by software industries?

1012


What is the function of ctrl e?

478


Expand BSBDA.

916


Explain what is object relationship overview?

426


What do you mean by pointer value and address?

899


What is the difference between dtd and xsd?

808


What all information is to be provided in the MDQ?

703


What do you understand by product costing in sap controlling? : cost center accounting

873


What is the disadvantage of a call by reference? : abap modularization

929


Explain difference between dim object as object and dim obj as myform?

897


What are the types of stored procedures in an sql server?

798