how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
- 6 Answers
- 5732 Views
- I also Faced
- E-Mail Answers
Answer Posted / roger
LIMIT 0,4 will return 5 records because it starts with 0.
It should be LIMIT 0,3
SELECT prodid, prodname FROM products limit 0,3
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
How can I create a database in mysql?
What is a join? Explain the different types of mysql joins.
What is mysql optimization?
What does do in mysql?
How do you kill a long running query in mysql?
How would concatenate strings in mysql?
What is append query?
How do I quit mysql?
How to enable or disable a row of a table using MySQL in struts?
What is mysql root?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
How do I rename a table in mysql workbench?
What is the maximum connection pool size?
Can you tell which of the following where clauses is faster?
How to determine the location of the data directory?
