Answer Posted / prasadkonnur

select id from tbl_name order by id desc limit(0,1)

(selects 2nd highest id)

for nth highest

select id from tbl_name order by id desc limit(n-1,1)

How many columns is too many mysql?

896

---

What is pdo mysql?

919

---

What is a tinyint in mysql?

903

---

How to store values to array from mysql database in php?

936

---

How do I create a mysql database?

913

---

Is sql and mysql same?

918

---

How do I use mysql?

881

---

What are the types of queries?

940

---

How triggers can be used in mysql?

1003

---

How to get a version of mysql?

1035

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1013

---

What are the differences between binary and varbinary?

1041

---

What is data in mysql?

896

---

how to display nth highest salary from a table in a mysql query? : Mysql dba

1059

---

What is the use of mysqli_fetch_assoc?

897

---