how to find the second highest salary from emp table?
Answer Posted / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 754 Yes | 97 No |
Post New Answer View All Answers
What has stored procedures in sql and how we can use it?
What are the benefits of triggers?
Can we use views in stored procedure?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is a .db file?
How do I run a sql query in pgadmin 4?
What is sql and db2?
What is difference between cursor and trigger?
How to sort the rows in sql.
What makes a good primary key?
What is a temporal data type?
Can we use distinct and group by together?
What are conditional predicates?
Is there a 64 bit version of ssms?
What are the sql versions?