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

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

What is an execution plan?

0 Answers  

---

What are alternate keys?

0 Answers  

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

How to search for a string in all stored procedure in sql server?

0 Answers  

---

Define views.

0 Answers  

---

What are the types of subquery?

0 Answers  

---

How do I edit a procedure in sql server?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

Explain an automatic checkpoint

0 Answers  

---