Answer Posted / veeresh kethari

with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2856

---

Can a unique index be created on a column, which contains null?

968

---

What are the differences between stored procedure and view in sql server?

1316

---

How to change parameter value inside the report?

169

---

What happens if an integer is too big for int date type?

1027

---

What is transaction server isolation?

1092

---

What is compression - row-level and page-level compression?

962

---

What are the advantages of using cte?

1076

---

How to remove duplicate rows from table except one?

1064

---

what are constraints? : Sql server database administration

1132

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

1004

---

Explain what is public role in sql server?

1192

---

What different steps will a sql server developer take to secure sql server?

1039

---

Explain what are the authentication modes in sql server?

1073

---

How do use Having,Group by,Group function in SQL?

1789

---