find out the third highest salary?
Answer Posted / divya
select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is different types of joins?
What is PL/SQL ?
Which is faster join or subquery in oracle?
What language does oracle use?
What is a select query statement in oracle?
How to export data to a csv file?
defination of bitmap index
Define oracle database
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.
What is a database table in oracle?
Difference between inner join vs where ?
What is columnar storage what is the advantage?
Explain an index segment?
What are the logical operations?
What is the usage of synonyms?