a query to select maxmun 3 salaries of employee table
- 12 Answers
- 16813 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / ron
if you need to select by department then analytic function
is more readable:
1. use row_number() partition by dept order by sal desc as rn,
2. in where clause choose rn <4;
you can use rank() instead; if 2 or more employees have same
salary.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to pass parameters to procedures in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
candidate key is subset of super key but not vice-verse explain
State any two functions of oracle?
What are the uses of Database Trigger ?
What are the attributes that are found in a cursor?
How to assign a table row to a record variable?
How to connect to a remote server?
What are the varoius components of physical database structure of oracle database?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
what is reindexing?
Is there a function to split a string in plsql?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
