how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21533 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to change the name of a database user?
What is the sql server 2000 version number?
How to see the event list of an existing trigger using sys.trigger_events?
What is the difference between executequery () and executeupdate ()?
What is the purpose of forms?
do views contain data ?
What is difference between index and primary key?
Explain insert into select statement?
What is wide table?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
what stored procedure would you use to view lock information? : Sql server administration
What do you mean by a Composite primary key?
Mention the different types of triggers?
Explain temporary table vs table variable by using cursor alternative?
