how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
Answer Posted / ashim pal
set rowcount 5
select * from table_name
| Is This Answer Correct ? | 7 Yes | 16 No |
Post New Answer View All Answers
How to count groups returned with the group by clause in ms sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Which are ddl commands?
Explain what is the use of custom fields in report?
What is a non clustered primary key?
What is SubQuery in SQL Server 2008
How to create a testing table with test data in ms sql server?
What is cte (common table expression)?
What is the difference between Stored Procedures and triggers?
What happens if null values are involved in arithmetic operations?
How to specify the collation for a character data type in ms sql server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What are the types of database schema? : sql server analysis services, ssas
What is snapshot replication?
what is a transaction and what are acid properties? : Sql server database administration