Answer Posted / debasish

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

How secure is sql server database?

1016

---

Tell me what are cursors and when they are useful?

957

---

What are the restrictions while creating batches in sql server?

1064

---

What is a primary key?

955

---

Do you know what are pages and extents? : SQL Server Architecture

996

---

What do you mean by recursive stored procedure?

956

---

Define inner join in sql server joins?

1064

---

How to delete existing rows in a table?

1169

---

Write down the syntax and an example for create, rename and delete index?

990

---

Can sub report data source be different from that of the parent report?

143

---

What is an indice?

1043

---

What is the simplest way to create a new database in ms sql server?

1011

---

How to create a user name in a database?

1060

---

Explain the stored procedure?

1057

---

Explain filtered indexes benefits?

1003

---