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)?
- 16 Answers
- 23427 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
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
What do you mean by acid?
What are the differences between user defined functions and stored procedures?
What do you mean by tablesample?
What is difference between views and tables?
Explain what is public role in sql server?
What is scalar user-defined function?
What is the difference between local and global temporary tables?
Can two different columns be merged into single column? Show practically?
What is blocking and how would you troubleshoot it? : sql server database administration
What is instead of dml trigger?
How can I tell if sql server is 32 or 64 bit?
why would you call update statistics? : Sql server database administration
What is database dimension? : sql server analysis services, ssas
Comment,Datatypes are unlimited
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
