how to find the second highest salary from emp table?
Answer Posted / chandan
select slary from emp order by slary desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to return multiple rows from the stored procedure?
What is the difference between the sql*loader and import utilities? : aql loader
How do I view tables in mysql?
Explain the select statement in sql?
Can you skip header records while loading? : aql loader
Which software is used for pl sql programming?
What are the different type of joins in sql?
Is primary key an index?
What is sql and also describe types of sql statements?
what is the difference between delete and truncate statement in sql? : Sql dba
Is sql similar to python?
What is 19 null in sql?
What is asqueryable?
explain about mysql and its features. : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?