how to get 25th row in any table in sqlserver can u tell me syntax

Categories >> Software >> Databases >> SQL Server
Suggest New Category

how to get 25th row in any table in sqlserver can u tell me
syntax

Question Posted / srinukatkam

8 Answers
11735 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / sujitha

For Example TableName: Employee. Employee Have The
Following Fields.
Emp_No ( Identity Value)
Emp_Name
Designation

Select Top 1 * From Employee Where Emp_No Not in(Select
Top 24 Emp_No From Employee)

Is This Answer Correct ?

13 Yes

2 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / anand k

For Ex. We are Using State Table for this scenario.

Records In State Table is (Total 50 Rec)
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
--------

Now we are Selecting 25th record from the state table.

SELECT STA.*
FROM [State] STA,
(SELECT StateName,ROW_NUMBER() OVER (ORDER BY StateName)
ROWNO FROM [State] ) ROW
WHERE ROW.ROWNO = 25
AND ROW.StateNAme = STA.StateName
ORDER BY StateName

Is This Answer Correct ?

4 Yes

3 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / pradyumna

set rowcount 25
declare @temptable table
(id int identity(1,1),itemid int)
insert @temptable
select itemid from tbl123

select * from tbl123 where itemid=(select itemid from
@temptable where id=25)

Is This Answer Correct ?

0 Yes

0 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / nagaraju jella

select *
from securitytest_64.userroles u
where rowid =
(select max(rowid) from securitytest_64.userroles u
where rownum < 26)

Is This Answer Correct ?

0 Yes

0 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / svreddy

select *from emp a where 25=(select count(distinct(eno))from emp b where a.eno>=b.eno

Is This Answer Correct ?

0 Yes

0 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / manub22

Check here how to get 2nd of nth highest record from a table: http://sqlwithmanoj.com/2014/01/05/sql-trivia-find-second-or-nth-highest-salary-or-marks/

Is This Answer Correct ?

0 Yes

0 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / a.alagu ganesh

We create index colomn in that table . use that index
coloum we take the 25th row of that table .

Example

SELECT * FROM table1 WHERE index_coloumn = 25

Is This Answer Correct ?

4 Yes

8 No

how to get 25th row in any table in sqlserver can u tell me syntax..

Answer / venkat

suppose the table x having a column with name empid

set rowcount 25
select * from x where empid not in (select top 24 empid
from x)

Is This Answer Correct ?

1 Yes

6 No

Post New Answer