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

Explain partitioned view?

807


Why is sql server log file full?

745


Can we take the full database backup in log shipping?

717


Equi join and non equi join is possible with sql server?

661


How to use copy and concatenate commands in SQL?

776






Does a sql server 2005 select statement require a from?

774


What is a print index?

662


How do I clean up sql server transaction log?

742


Explain raiserror in sql server?

753


Explain full-text query in sql server?

717


Tell me about pre-defined functions of sql?

859


Can a database be shrunk with users active?

797


How to execute stored procedure in select statement sql server?

714


Explain mixed authentication mode of sql server?

717


How to how to convert numeric expression data types using the convert() function??

722