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

Can we use session in mvc?

941

---

Tell me what is the use of isset() in php?

997

---

Explain me difference between mysql_connect and mysql_pconnect?

908

---

What is stdclass in php?

905

---

"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.

1897

---

Which is better php or nodejs?

907

---

Name and explain five of the PHP error constants?

894

---

What is the use of offset in mysql?

888

---

What is namespaces in PHP?

938

---

How many keywords are there in php?

1072

---

What is api used for?

872

---

What is the most convenient hashing method to be used to hash passwords?

934

---

Why php is also called as scripting language?

912

---

A process can run only in the background. State Whether True or False?

1064

---

How to redirect https to http url and vice versa in .htaccess?

925

---