Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15703 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / keerthi
select(max(salary)
from employee
where sal>max salary&salary<max salary-1;
if you say no to my answer plz correct me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an Oracle index?
What is pragma autonomous transaction in oracle?
What language does oracle use?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is ordinary table in oracle?
What is oracle database client?
Explain the use of indexes option in imp command.
Explain the use of control file?
Can we save images in a database and if yes, how?
Explain how are indexes update?
What is a partition in oracle?
How to define an oracle cursor variable?
How many categories of data types?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to create a stored program unit?
