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

Ness Technologies SQL PLSQL Interview Questions
Questions Answers Views Company eMail

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 13556

Post New Ness Technologies SQL PLSQL Interview Questions


Ness Technologies SQL PLSQL Interview Questions


Un-Answered Questions

Which is not a php magic constant?

687


What is the advantage of spring mvc?

204


What is the difference between merge and update method?

257


How to restart a wpf application programmatically?

227


how many sql ddl commands are supported by 'mysql'? : Sql dba

649






how can service sitting be setted for MCCB?Example for sittings IR (CURRENT RATING),IS(CURRENT STARTING)IO (current operating)?

1524


Why doesnt the call scanf work?

821


What are the restrictions that views have to follow? : SQL Server Architecture

661


What do you mean by blocks in the blockchain technology?

5


What will happen if the user don’t have 'Read' security on a field?

534


What are the causes of damage to propellers?

1677


What is dual data format in qlikview?

5


What is the concatenation operator?

720


7. Give me an example of a time when you have tried to accomplish something, and failed

4156


Can we join more than 2 tables in sql?

618