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

What is encryption key?

119

---

How does a profiler work?

882

---

How to list all dsn entries on your local machine using odbc_data_source()?

991

---

what is a join and explain different types of joins? : Sql server database administration

925

---

How to use wildcard characters in like operations in ms sql server?

1080

---

How to write a query with an inner join in ms sql server?

1009

---

Mention what are the core components of ssrs?

298

---

What is acid properties?

1034

---

What is report snapshot in ssrs?

253

---

What do you mean by collation recursive stored procedure?

1028

---

What is the process of normalising?

961

---

How many levels of sp nesting is possible?

1009

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1075

---

What are the ways available in sql server to execute sql statements?

1059

---

What is the difference between clustered and non-clustered indexes in ms sql server?

957

---