Answer Posted / tulasi ravi kumar

hi,
my id is ravi106109@gmail.com

select sal from emp a
where 1=(select count(b.sal) from emp b
where a.sal<b.sal) order by sal desc;

and also dileep is write

What are the different types of replication you can set up in sql server?

985

---

List out some of the requirements to set up a sql server failover cluster?

981

---

How to sort the query output with order by clauses in ms sql server?

984

---

What is database mirroring?

1041

---

What are the security related catalog views? : sql server security

914

---

Does partitioning help performance?

891

---

How do I find information about the install locations for the various instances running on a computer?

1033

---

What is an execution plan?

1059

---

Name few of the dcl commands in sql?

952

---

What is sql view?

956

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1118

---

How do I setup a sql server database?

1004

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

982

---

Explain how does the report manager work in ssrs?

903

---

What is analysis service repository?

969

---