Answer / ravinder pawar

Hi Frnds,
Pravin's logic is correct. I am just modifying it little
bit.

Select Top 1 *
From (Select Top 5 *
from HumanResources.Employee
order by EmployeeID desc)as temp

---Note If we don't use temp we'll get error as mentioned
below:
Incorrect syntax near ')'.

Answer / pravin s. ahire

Select Top 1 *
From (Select Top N * from tablename order by
table.ColumnName desc)

-- where N = nth record

Answer / sajida

--For ex in dept table to select 5th record. Instead of
this you can use &n so that it can ask row number

select rnum, d.* from dept d, (select rownum rnum ,
deptno from dept ) e
where d.deptno = e.deptno and rnum = 5

How to create a simple table to test triggers in ms sql server?

0 Answers  

---

Explain use of expression builder.

0 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

Explain index in sql server?

0 Answers  

---

What is delete query?

0 Answers  

---

What is a Join and explain its types?

0 Answers  

---

What is resource db in sql server?

0 Answers  

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

What are the benefits of filtered indexes?

0 Answers  

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,

---