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 does the file with the extension: frm, myd, and myi contain?

0 Answers  

---

Is mysql written in c?

0 Answers  

---

How can you change the name of any existing table by using the sql statement?

0 Answers  

---

What is mysql sleep process?

0 Answers  

---

How we get sum of column.

0 Answers  

---

---

How we can copy one table data into another table whose name same as table but in differ database

8 Answers  

---

How do I change the max connections in mysql?

0 Answers  

---

What do you understand by mysql terminal?

0 Answers  

---

Can you save your connection settings to a conf file?

1 Answers  

---

How many services is running in sql server?

3 Answers   ACC, V2 Solutions,

---

What is difference between mysql mysqli and pdo?

0 Answers  

---

Write command to import an mysql file?

0 Answers  

---