Answer Posted / subhranghshu bhattacharjee

first find second largest salary in the emp database:

select min(sal)sal from(select sal from emp order by sal
desc)
where rownum<3
u can find 3rd,4th... so on ,only change rownum
like rownum<4,rownum<5 ... so on

What are the types of indexes?

1082

---

What are subquery and its properties?

1049

---

What stored by the master? : sql server database administration

1109

---

How to create a new login name in ms sql server?

1062

---

What is the Disadvantage of indexed sequential file.

1082

---

Explain partitioned view?

1068

---

What is the difference between mysql and sql server?

1022

---

Does order by actually change the order of the data in the tables or does it just change the output?

1145

---

How raid can influence database performance?

1030

---

What are the pre-defined functions in the sql server?

1108

---

How does stuff differ from the replace function?

1010

---

What command would you use to add a column to a table in sql server?

1307

---

whats new about truncate in sql server 2008?

2501

---

How can we remove orphan records from a table?

982

---

Write the syntax for stuff function in an sql server?

1024

---