Answer Posted / lekhraj deshmukh

select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;

How to return query output in html format?

933

---

Why do we use group by and order by function in mysql?

920

---

What are the limitations of mysql?

1048

---

How to check if a record exists in a mysql database php?

890

---

How to delete a column and add a new column to database

944

---

all the queries used in sql

2657

---

How to find second highest salary from a table?

1022

---

write a command to view the content of the table

899

---

What is the use of mysqli_fetch_assoc?

903

---

Where the database is stored in mysql?

967

---

How do I install and use mysql?

935

---

What is ibdata1?

909

---

How to write date and time literals?

1030

---

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

884

---

How do I setup a mysql database?

980

---