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

How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain

952

---

What is get and post method in php?

963

---

Is php easier than javascript?

960

---

What are the 5 types of variables?

974

---

What are sql functions?

915

---

What is the function of string in c?

976

---

Can we use session in mvc?

960

---

Tell me what are the encryption techniques in php?

901

---

How to remove the new line character from the end of a text line?

955

---

What is difference between md5 and SHA256?

1021

---

Which function would you use to merge two arrays in php?

939

---

How can we destroy the cookie in php?

943

---

How cookies are transported from browsers to servers?

910

---

What is use of htmlspecialchars php?

988

---

What is php used for?

938

---