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
- 22594 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
In what version of sql server were synonyms released?
What is the Disadvantage of indexed sequential file.
What is the most common trace flags used with sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the parse query button used for?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What extended events?
How can you check the level of fragmentation on a table?
How fixed length strings are truncated and padded?
How can sql server instances be hidden?
Why we use the openxml clause?
which backup strategy you are following at ur company
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is collation sensitivity? Explain different types.
How to include text values in sql statements?
