how to select 5 to 7 rows from a table, which contains 10 rows?

Answers were Sorted based on User's Feedback



how to select 5 to 7 rows from a table, which contains 10 rows?..

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........

Is This Answer Correct ?    25 Yes 3 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

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

Is This Answer Correct ?    13 Yes 2 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / smitha

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

Is This Answer Correct ?    7 Yes 3 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / s. ramesh

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

Is This Answer Correct ?    3 Yes 2 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / priyanka

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

Is This Answer Correct ?    2 Yes 1 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / narayana

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

Is This Answer Correct ?    1 Yes 0 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

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;

Is This Answer Correct ?    2 Yes 2 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / kaviraj.y

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

Is This Answer Correct ?    0 Yes 0 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

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

Is This Answer Correct ?    1 Yes 1 No

how to select 5 to 7 rows from a table, which contains 10 rows?..

Answer / pravnch

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  


What is clustered primary key?

0 Answers  


When to use Inner join & when to use subquery?

0 Answers   IBM,


What is the difference between createstatement and preparedstatement?

0 Answers  


What are scheduled tasks in sql server?

0 Answers  






What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  


How do you debug a procedure in sql server?

0 Answers  


What is merge join?

0 Answers  


What are binary string data types in ms sql server?

0 Answers  


how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  


What happens to a trigger with multiple affected rows?

0 Answers  


Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  


Categories