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
- 23392 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / anup kumar pandey
There are two methods
1> select top 1(name) from anuppandey
or
2>select top 5o percent name from anuppandey
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain concepts of analysis services?
What are built in functions?
What is the fillfactor concept in indexes?
How you can get the list of largest tables in a database?
What is store procedure? When do you use?
Which tcp/ip port does sql server run on? How can it be changed?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Explain transaction server explicit transaction?
What are the different methods available under sqlcommand class to access the data?
Ways to improve the performance of a SQL Azure Database?
What are the three different part of rdl file explain them?
What are ddl (data definition language) statements for tables in ms sql server?
