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 / 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
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is awe?
What is raid and what are different types of raid levels?
Is sql server is free?
What do you understand by recursive stored procedures?
What are cascading parameters in ssrs reports?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How check triggers in sql server?
Can I save my report as html, excel or word? : sql server management studio
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are distinctive joins find as a part of sql?
Explain what is dbcc?
What is the difference between substr and charindex in the sql server?
What do you understand by replication in sql server?