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

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

What is the most common trace flags used with sql server?

0 Answers  

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

Where are full-text indexes stored?

0 Answers  

---

What is the concept of optimization?

0 Answers  

---

What is row by row processing ?

2 Answers  

---