Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26303 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 system functions or built-in functions? What are different types of system functions?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Which sql server is best?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is application role in sql server database security? : sql server security
What is scalar user-defined function?
How to check table values in sql server?
Mention a few common trace flags used with sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to view existing indexes on an given table using sp_help?
What are the new features of sql server 2012 reporting service?
Is the primary key column of a table an index in ms sql server?
What is temporary stored procedure?
What are the new data types are introduced in sql 2000?
What is cached report?
