Answer Posted / prasant palo

with ttble as
(
select top 3 empid,empname,empsalary
from
emptable
order by empsalary desc
)
-- above will create a common table expression with name
--ttable
-- to know about it search for commontable expression
select top 1 empid,empname,empsalary
from
ttable
order by empsalary asc

How can you check the level of fragmentation on a table?

1087

---

What is the difference between having clause and where clause in sql server?

1169

---

What causes index fragmentation?

1045

---

What happens if you are trying to access a schema not owned by you?

1020

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1021

---

How to generate random numbers with the rand() function in ms sql server?

1226

---

How to recreate an existing index in ms sql server?

1117

---

How to copy data from one table to another table?

1051

---

Explain how you can deploy an SSRS report?

156

---

How to connect to a sql server using odbc_connect()?

1204

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1158

---

Explain the relational database management system (rdbms)?

1162

---

Write down the syntax and an example for create, rename and delete index?

1027

---

Can binary strings be used in arithmetical operations?

985

---

Explain the properties of a relational table?

1077

---