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
Answer Posted / vigneshram
select nid, prodname from products limit 0,4
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How do I select a database in mysql?
How can we encrypt and decrypt a data presented in a table using mysql?
How do I drop a database in mysql?
What is the current version of mysql?
What is a result set object?
Where is mysql data stored?
Why do we use pragma autonomous transaction?
Does mysql case matter?
How do I delete a table in mysql workbench?
What is mysql sleep process?
What is datatype in mysql?
What is prepare statement in mysql?
Is mysql a framework?
What is max_used_connections in mysql?
Why mysql is open source?