Answer Posted / vijay

select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal

How to run queries with sql server management studio express?

1038

---

What is data source in connection string?

872

---

What is sub-query in sql server? Explain its properties.

1056

---

What are window functions in sql server?

961

---

what is a deadlock? : Sql server database administration

1010

---

When you should use a low fill factor?

957

---

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

161

---

What are three major types of constraints?

1068

---

Tell me about joins in database system and explain each in detail.

1017

---

What stored by the msdb?

966

---

how to control the amount of free space in your index pages? : Sql server database administration

1003

---

What are the types of sql server?

1012

---

What is report subscription?

123

---

Explain indexes disadvantages?

1033

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

875

---