Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

What is full outer join in sql server joins?

1140

---

Explain having clause?

1030

---

Explain for xml explicit mode?

1028

---

What is difference between getdate and sysdatetime in sql server 2008?

1099

---

What is rs.exe utility?

164

---

What is difference between view and materialized view?

987

---

How to include date and time values in sql statements?

1144

---

How to create a large table with random data for index testing in ms sql server?

1071

---

How can I check that whether automatic statistic update is enabled or not?

1097

---

How to create a stored procedure with a statement block in ms sql server?

1129

---

what is a transaction and what are acid properties? : Sql server database administration

1090

---

What is query processing?

990

---

What is the process of normalising?

1049

---

Explain the difference between control flow and data flow?

1061

---

How do I find the transaction log size in sql server?

1005

---