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 / 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 is the synonym of join?
How do use Having,Group by,Group function in SQL?
What are different types of subquery?
Explain the dbcc pintable command when would you use it?
Where do you find the default Index fill factor and how to change it?
Do you know what are acid properties?
What is global temp table?
what is the system function to get current user's user id? : Sql server database administration
How to download microsoft sql server 2005 express edition?
What is data source object?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Explain the stored procedure?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the function of sql server agent windows service?
How to execute multiple stored procedures at one time in sql server?