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
- 21542 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
What are clustered and non-clustered index?
What is the difference between Normalization and De-normalization?
What type of locking occurs during the snapshot generation? : sql server replication
Mention the differences between local and global temporary tables.
What is deploy, process and build? : sql server analysis services, ssas
Explain what are the basic functions for master, msdb, model, tempdb databases?
What happens if null values are involved in bitwise operations?
How many full-text indexes can a table have?
Explain how you can deploy an SSRS report?
How to start and end transact-sql statements?
How to replace null values in expressions using isnull()?
How to transfer an existing table from one schema to another schema in ms sql server?
what is memory-optimized nonclustered indexes
How adventureworkslt tables are related?
How to perform key word search in tables?
