how to find 2nd highest salary in random database salary of employer.....
Answer Posted / arnab das
select distinct column_name from table_name order by
column_name desc limit 1,1
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How do you select a table?
What is join in mysql? What are the different types of join?
What is the use of pdo?
Describe mysql transaction properties.
How do I download mysql on my laptop?
What is foreign key in mysql?
What is the data type for file in mysql?
How many columns can a mysql table have?
what is constraints? Also explain the different types of constraints?
List some mysql advantages and disadvantages?
What is mysql database server?
How to get last inserted id after insert data from a table in mysql?
What are the similarities between a function and a procedure?
Which is better sqlite or mysql?
Is mysql still popular?