How to select nth record from a table?
Answers were Sorted based on User's Feedback
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 ')'.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / pravin s. ahire
Select Top 1 *
From (Select Top N * from tablename order by
table.ColumnName desc)
-- where N = nth record
| Is This Answer Correct ? | 0 Yes | 3 No |
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
| Is This Answer Correct ? | 5 Yes | 10 No |
How can you see what type of locks used?
What is the correct order of the logical query processing phases?
What are the type of joins? When do we use Outer and Self joins?
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.
Working with TLogs
What do you mean by authentication modes in sql server?
List all types of constraints in sql server?
What are the types of resultset?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
can you any body tell me the difference between candidate key and primary key
explain different types of jions with examples briefly?
Can we do dml on views?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)