Answer Posted / kavitha.r

Sorry. This one is correct


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

What is coalesce and check constraint in sql server?

1067

---

How do I trace a query in sql server?

920

---

What information is maintained within the msdb database?

939

---

What is the exact numeric data type in sql?

978

---

When you should use a low fill factor?

957

---

Explain system functions or built-in functions? What are different types of system functions?

935

---

What is ms sql server triggers?

977

---

Do I need a report server to run reports in my application?

161

---

How can we get count of the number of records in a table?

921

---

How do you Implement SSIS Packages in your Project?

1889

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1015

---

How to download microsoft sql server 2005 express edition?

1006

---

How to delete a login name in ms sql server?

1026

---

What is transaction server explicit transaction?

994

---

What is a select query statement in ms sql server?

1027

---