Answer Posted / raman sharma

For third highest salary u can use this syntax

select min(cin) from ( select distinct cin from
cws.usertable order by cin desc ) where rownum<4

What are the advantages of stored procedure in sql server?

933

---

What is the order in which the sql query is executed?

994

---

What is the difference between join and inner join?

1074

---

What are the key configuration files for sql server reporting services ?

171

---

can a database be shrunk with users active? : Sql server administration

1063

---

Can a function call a stored procedure in sql server?

1005

---

what are the new features in SSRS?

147

---

How to create function with parameter in sql server?

1158

---

What is difference between equi join and inner join?

1041

---

What are logical/boolean operations in ms sql server?

1104

---

How to filter records of table in SQL SERVER?

1134

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1174

---

How do you rebuild an identity column?

997

---

What are the types of indexing?

1119

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1010

---