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
- 23406 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / sneha s
fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pivot and unpivot?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How is sql used in sql server?
List out the different types of locks available in sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are advantages of ssrs or why we should use ssrs?
What is a primary key?
Explain transaction server consistency?
How to retrieve field values using mssql_result()?
What is cdc in sql server?
How except clause is differs from not in clause?
What stored by the master?
Where is trigger in sql server?
Can one drop a column from a table?
