Answer Posted / ravindra babu

select sal from (select sal from(Select distinct sal from
EMP order by sal desc)Where rownum <=2 order by sal asc)
Where rownum=1;

What are recommended options to be used while using db mirroring? : sql server database administration

1154

---

What are the dis_advantages of stored procedures, triggers, indexes?

2226

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1944

---

How to throw custom exception in Stored Procedure?

1044

---

what are constraints? : Sql server database administration

1056

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1945

---

What is service broker?

1005

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1093

---

How do you delete duplicate rows in sql server?

955

---

What is meant by indexing?

1022

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1101

---

What is difference between delete & truncate commands?

1081

---

What is the difference between createstatement and preparedstatement?

940

---

What is sql sandbox in sql server?

1222

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1002

---