Answer Posted / saritha

select distinct top 2 salary from EMP order by salary desc

Do you know how to store and query spatial data?

1087

---

Can you explain powershell included in sql server 2008?

990

---

How to round a numeric value to a specific precision?

1126

---

What do we have to check in database testing?

1056

---

How to change the name of a database user?

1010

---

What is the use of for clause?

1163

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1073

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1101

---

How many cores do I need for sql server 2016?

951

---

Do you know what guidelines should be followed to help minimize deadlocks?

1014

---

What is a recursive stored procedure in sql server?

1243

---

What is difference between index seek vs. Index scan?

1200

---

What are audit control procedures?

1034

---

What are the differences between having and where clause.

1016

---

What is a partition key?

1030

---