how to get second highest salary in SQL(as/4000
Answer Posted / c srirammulu
select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What problem one might face while writing log information to a data-base table in pl/sql?
What do you mean by stored procedures? How do we use it?
Explain the difference between triggers and constraints?
How do I add a database to sql?
What's the difference between a primary key and a clustered index?
What are all the different normalization?
how to use like conditions? : Sql dba
What is compound trigger?
What is posting?
How does postgresql compare to "nosql"?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
How many types of indexes are there in sql?
What is rank dense_rank and partition in sql?
Does pl sql work in mysql?
what is 'mysqlshow'? : Sql dba