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);

Write a program to get lcm of two numbers using php?

1014

---

What is the Pipe Symbol represented?

1157

---

How to read a file in binary mode?

1160

---

"mysql_fetch_row — Get a result row as an enumerated array",this sentence comes from the PHP offical manual.However ,i can not understand the words "enumerated array".I need some help.Thanks a lot to everyone that reply.

1995

---

What is difference between base_url and site_url?

1072

---

am from coimbatore.am learning php&mysql. what will be the approx salary for me if i get a job in coimbatore.

2126

---

What is use of count() function in php?

1104

---

Is laravel an oop?

968

---

What is the alternative structure for control structures?

1146

---

Why print_r is used in php?

999

---

How to pass variables and data from php to javascript?

1100

---

What is isset php?

1016

---

How do you access a get requests url parameter with php?

1062

---

Why php language is used?

1028

---

What is the apache?

996

---