Answer Posted / prakash.matte

if we want to make use of nested query instead of the above,
try the following

select max(column_name) from table_name where column_name =
(select
max(column_name)-(highest_salary_number_for_calculation -1)
from blocks where bid);

Example :

For second highest salary:

select max(bid) from blocks where bid = (select max(bid)-1
from blocks);

For third highest salary:

select max(bid) from blocks where bid = (select max(bid)-2
from blocks);

What is csrf mvc?

1028

---

What is the use of preg_match in php?

996

---

What is singleton pattern in php?

891

---

What the difference between the 'bitwise and' operator and the 'logical and' operator?

966

---

What are the benefits of composer?

1008

---

How we load all classes that placed in different directory in one php file , means how to do auto load classes.

979

---

What is the method to register a variable into a session?

849

---

What is the function mysql_pconnect() useful for?

949

---

Is PHP an open source software?

1055

---

What is the difference between implode() and explode() in php?

1025

---

Suppose we receive a form submitted by a post to subscribe to a newsletter. This form has only one field, an input text field named email. How would we validate whether the field is empty? Print a message "the email cannot be empty" in this case?

1134

---

Is php easier than javascript?

988

---

What is a lambda function in php?

1092

---

What is restful api?

948

---

Does php 7 support mysql?

1004

---