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 127677

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 13042

Post New Deloitte SQL PLSQL Interview Questions


Deloitte SQL PLSQL Interview Questions


Un-Answered Questions

How is csrf token generated?

505

why servomotor motor? where i apply for best output?

1550

In which order, we upload data in salesforce for related objects? : salesforce Data Management

211

Explain how to rename a table using sql queries?

549

Which type of variable among global and local, takes precedence over other if names are same?

495




What is hot backup and logical backup?

602

Tell us about your oncology experience.

2041

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1767

What are the basics of core java?

544

Can you explain various data region available in ssrs with their use?

544

tell me the setting database configuration.

323

What are the different modes of service invocation?

625

Is apache still used?

500

What are the Collection types in Hibernate?

149

What is the meaning of global employment in sap hcm?

577