Answer Posted / akilis.org@hotmail.com

Let us Assume
Table Name=salary
Column Name=maxsal

select * from salary order by maxsal desc limit 2,1;

Enjoy the simple code :)

How to return multiple rows from the stored procedure?

970

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

explain the delete statements in sql

1060

---

Difference between truncate, delete and drop commands?

1082

---

what is bdb (berkeleydb)? : Sql dba

1034

---

What are inner and outer joins examples of both?

963

---

how to check myisam tables for errors? : Sql dba

1321

---

Where not exists in sql?

980

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4025

---

Which join is like an inner join?

1027

---

What is primary key secondary key alternate key candidate key?

1037

---

How to get each name only once from an employee table?

1116

---

Which is better trigger or stored procedure?

950

---

How does left join work in sql?

1006

---

What is sql and how does it work?

1175

---