Answer Posted / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

Can binary strings be converted into numeric or float data types?

994

---

What is the maximum size of column in sql server?

864

---

What do we have to check in database testing?

983

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1021

---

What are views in ms sql server?

1046

---

How dts is used to extract, transform and consolidate data?

1044

---

Explain subquery and state its properties?

990

---

What is cte (common table expression)?

996

---

What is SQL Azure Federations?

112

---

Explain what is “asynchronous” communication in sql server service broker?

886

---

What is a collation in ms sql server?

1031

---

How do I manually uninstall an instance of sql server 2016?

985

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1004

---

What is the difference between system objects and user objects?

1129

---