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 / sruthi

select top5 * from table
minus
select top4 from table

Is This Answer Correct ?    5 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the characteristics of modern DBMS?

628


How to execute a sql statement using mssql_query()?

551


Explain the dirty pages?

580


What is a functions and types in sql server?

600


Do you know how to implement service broker?

539






Define inner join in sql server joins?

535


What do you understand by recursive stored procedures?

572


How fixed length strings are truncated and padded?

558


How to drop existing indexes in ms sql server?

593


Is candidate a key?

538


What is SQL Azure Federations?

98


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

487


how you can get the list of largest tables in a database? : Sql server administration

559


What is read committed?

613


What is normalization and its types?

542