Write a query to find second highest salary of an employee.
Answer Posted / monika
select max(sal) from emp where sal<select max(sal) from emp
Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How can you fetch first 5 characters of the string?
How do I count rows in sql?
What is a left join?
What is a natural join?
Is left join same as inner join?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Does view contain data?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Does oracle roll back the transaction on an error?
What is a full join sql?
What is dba in sql? : SQL DBA
What are the types of functions in sql?
Does inner join return duplicate rows?
Mention what plvcmt and plvrb does in pl/sql?
What are the types of queries in sql?