how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / 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 |
Post New Answer View All Answers
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Can a table have 2 primary keys?
How to use values from other tables in update statements in ms sql server?
Define Wed Edition in SQL Azure?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the difference between Stored Procedures and triggers?
When a primary key constraint is included in a table, what other constraints does this imply?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is inner join? Explain with an example?
What are the dis_advantages of stored procedures, triggers, indexes?
What do you mean by 'normalization'?
What is the difference between Normalization and De-normalization?
What is normalization of database?
What is the default schema of your login session in ms sql server?