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 can you see what type of locks used?

1 Answers  

---

What is the correct order of the logical query processing phases?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

Working with TLogs

0 Answers  

---

What do you mean by authentication modes in sql server?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

What are the types of resultset?

0 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

Can we do dml on views?

0 Answers  

---