Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 12005

Post New Ness Technologies SQL PLSQL Interview Questions


Ness Technologies SQL PLSQL Interview Questions


Un-Answered Questions

What is xaml namespace?

97


What does keep source formatting mean?

200


What knowledge needed for web services publishing?

217


What are the difference between laravel 5 & laravel 4?

266


What do you mean by table control???Where will we use this?

1110






What are the chkdsk parameters?

280


How to move a drupal site from one host/server to another?

51


What do you mean by soap?

217


Explain timestemp datatype in sybase.

337


The best time to kill a foreground activity in Android?

504


What has stored procedures in sql and how we can use it?

378


What is case class? What is case object? What are the Advantages of case class?

5


What is electrophilic addition reaction?

416


Explain the properties of sub-query in sql server?

313


What is main difference between spring and spring boot? : Spring Boot

74