Answer / soorai ganesh

Should Implement ROW_NUMBER() method.

Just take this Example.

Create table emp(empid int, ename varchar(50),salary numeric
(9,2)

Insert into emp values(1,'Employee1',10000)
Insert into emp values(2,'Employee2',20000)
.
.
Insert into emp values(10,'Employee10',100000)

Consider the above table which have 10 records. Now u
want to select 5,6,7 Rows in this table. Just try this
query.

SELECT E.EmpID,E.EName,E.Salary FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY EmpID ASC) AS Rno, *
FROM emp
) E
WHERE E.Rno >= 5 and E.Rno <= 7

Thats all.
If anyone have other such good idea kindly share........

Answer / ayyappanramachandran

You can achieve this by using following Query

select * from(select top 3 * from employees where
employeeid in(select top 7 employeeid from employees where
employeeid not in(select top 4 employeeid from employees
order by employeeid)))e order by employeeid.

Thanks
AyyappanRamachandran

Answer / smitha

select * from (select row_number() over (order by empid) as
row, *
from employee)a
where a.row between 4 and 5

Answer / s. ramesh

select * from ( select rownum r, comp_name from metatest )
where r > 4 and r < 8;

Answer / priyanka

select top 3 * from emp where id not in
(select top 4 id from emp order by id)

Answer / narayana

select * from emp order by empid
offset 4 rows
fetch next 3 rows only

Answer / sajida

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

Answer / kaviraj.y

SELECT * from emp_table WHERE e_id>=5 AND e_id<=7;

Answer / tb

select a.empid, a.ename,a.salary from (select * from emp
order by empid desc LIMIT 6) b INNER JOIN (select * from
emp order by empid asc LIMIT 7) a on b.empid=a.empid

Answer / pravnch

Select EmpNo, EName,Sal from EmpTable where EmpNo between 5
and 7

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

Do you know exporting and importing utility?

0 Answers  

What is query optimization process?

0 Answers  

How many types of cursor type are there?

0 Answers  

Do you know nested transaction?

0 Answers  

How do I create a stored procedure in sql server?

0 Answers  

What is the server name for sql management studio?

0 Answers  

Explain how does the report manager work in ssrs?

0 Answers  

How to verify a user name with sqlcmd tool?

0 Answers  

Explain the difference between primary keys and foreign keys?

0 Answers