Answer Posted / 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.

Do I need to pay for mysql?

900

---

Can I use mysql for free?

905

---

What are the differences between char and nchar?

1101

---

What is row level locking in mysql?

1012

---

How to shut down the server with 'mysqladmin'?

967

---

How do I completely remove mysql from windows?

972

---

Explain csv tables.

1014

---

What is the data source name for mysql?

954

---

Does mysql support nosql?

916

---

How to store binary data in mysql?

1002

---

How do I uninstall mysql connector?

957

---

How many tables we can create in mysql database?

952

---

Is mysql a programming language?

908

---

Explain what is mysql?

1038

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2230

---