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 #temp and @table variable in SQL server?

0 Answers  

Can group by and orderby be used together?

0 Answers  

What are the differences between user defined functions and stored procedures?

0 Answers  

what is the query and condition to delete datas in sql server.

2 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

What are the different types of upgrades that can be performed in sql server?

0 Answers  

How to change the password of a login name in ms sql server?

0 Answers  

When is update_statistics command used?

0 Answers  

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

How to delete a login name in ms sql server?

0 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers