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
- 21604 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / vamsi krishna
select * from <table name> order by <column name> limit 0,5;
or
select * from <table name> limit 0,5;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can two different columns be merged into single column? Show practically?
What happens if you add a new index to large table?
How to create a store procedure with encryption?
What is the use of toad or sqldbx.?
What does top operator do?
What is relationship? What number of sorts of relationship are there?
what is database replication? : Sql server database administration
How do you send email on SQL Server?
What do you need to connect php to sql server?
What is sql server used for?
Do you know what are the properties of the relational tables?
how to create “alternate row colour”?
How do you know if sql server is running on your local system?
how to take backup bcp out for a column in table in sql server?
How do I uninstall sql server 2014?
