Answer Posted / dipti saxena

select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1

How to convert a unicode strings to non-unicode strings?

1047

---

What are the advantages of having an index on the sql server?

885

---

What is the default Port No on which SQL Server listens?

1087

---

How do I shrink an ldf file?

946

---

What are the differences between user defined functions and stored procedures?

1017

---

What language is sql server written in?

995

---

How to enter comments in transact-sql statements?

900

---

what is a deadlock? : Sql server database administration

1004

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

941

---

How sql server enhances scalability of the database system?

1141

---

What is difference between clustered and non clustered index?

939

---

Tell me the difference between clustered and non-clustered index?

898

---

Describe in brief databases and sql server databases architecture.

959

---

What is the benefit of normalization?

1031

---

What are points to remember while using the fillfactor argument?

922

---