Answer Posted / rajesh

In MS SQL I was able to run the query:
select min(sal) from emp where sal in ( select top 2 sal
from emp order by desc)

but i was not able to run similar query in MySQL 5.1.41


select min(e_sal) from employee where e_sal in (select e_sal
from employee order by e_sal desc limit 2);

MySQL gives the following error:

ERROR 1235 (42000): This version of MySQL doesn't yet
support 'LIMIT & IN/ALL/ANY/SOME subquery'

what is the use of friend function? : Sql dba

974

---

Can we use ddl commands in pl sql?

1074

---

Is it possible to create the following trigger: before or after update trigger for each row?

1238

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2451

---

what is self-join? : Sql dba

1057

---

What are database links used for?

994

---

Which data dictionary views have the information on the triggers that are available in the database?

1182

---

What is a scalar value in sql?

1014

---

What is multiple partition?

921

---

Can you join a table to itself?

1033

---

How do I debug a stored procedure?

1041

---

What is the difference between an inner and outer join?

963

---

I need a function for a train ticket reservation please answer it thanks in advance

957

---

How many tables can a sql database have?

927

---

What are the benefits of triggers?

1122

---