Answer / neelesh jain

LIMIT <n> == n rows will be returned
OFFSET <n> == skip n rows of the query result

SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT 1
OFFSET 1;

so above query skip 1 element (as offset is 1), which is
biggest and returned 1 elemetn which is 2nd largest value.

Answer / harish varma

SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 2,1

Answer / prashant chaudhary

select top 1 * from ( select top 3 * from Student_Info
order by marks desc)table1 order by marks

Answer / shanmukha

select min(salary) from Employee where salary in(select
distinct top 2 salary from Employee order by salary desc )

This is the query to find second maximum salary in MSSQL

Answer / sivsankar.ponnurangam

select project_id from tbl_project order by project_id
desc limit 2,1

What are the difference between mongodb and mysql?

1 Answers  

How do I select a database in mysql workbench?

0 Answers  

How do you concatenate strings in mysql?

0 Answers  

What is the limit of mysql database?

0 Answers  

How do I connect to a mysql database?

0 Answers  

Is mysql still relevant?

0 Answers  

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

What are HEAP tables in MySQL?

1 Answers  

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 Answers  

Where is the mysql data directory?

0 Answers  

What are the advantages of mysql?

0 Answers  

Which is better sqlite or mysql?

0 Answers