Answer Posted / vamsi krishna

For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);

what is the system function to get current user's user id? : Sql server database administration

1008

---

What is the Main Difference between ACCESS and SQL SERVER?

1141

---

Explain partitioned view?

1086

---

What is query optimization process?

1016

---

What is RAID? What are the different types of RAID configurations?

1136

---

Find columns used in stored procedure?

991

---

Which sql server is best?

999

---

How to download and install the scaled-down database adventureworkslt?

992

---

Can you pass expressions to function parameters?

1103

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1024

---

What is the significance of null value and why should we avoid permitting null values?

989

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1065

---

What is the purpose of self join?

975

---

Disadvantages of the indexes?

1125

---

why would you call update statistics? : Sql server database administration

1091

---