how to get 25th row in any table in sqlserver can u tell me
syntax
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How does a profiler work?
What do you mean by cardinality?
What is replication with database mirroring? : sql server database administration
What type of Index will get created after executing the above statement?
What is difference between drop truncate and delete?
Creating Tables Using SELECT
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What is the downside of using udf?
What is the difference between online clustering and Offline clustering?
What are the differences between stored procedure and the dynamic sql?
What is an index. What are the types?
What is a trace frag?