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

Explain microsoft sql server functions?

1117

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1684

---

How to provide default values to function parameters?

1146

---

What is triggers and stored procedures?

943

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

935

---

what kind of lan types do you know? : Sql server database administration

980

---

Do you know clustered and non-clustered index?

979

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1076

---

Difference between Sql server reporting services and Crystal reports?

172

---

Which tools are available to manage SQL Azure databases and servers?

115

---

Difference between 2NF &3NF ?

1089

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1091

---

What are relationships and mention different types of relationships in the dbms

962

---

plss anybody specify tha constrian management system in dbms

2154

---

Tell me what are cursors and when they are useful?

956

---