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
Can we rollback truncate in mysql?
Why is the basic difference between left join, right join and inner join?
Can we write procedure in mysql?
How do I know if mysql is running on windows?
Explain the difference between mysql and mysql interfaces in php?
Which statement is used to delete a table in MySQL.
Is mysql an oracle product?
List the different types of normalization?
What is the hostname for mysql database?
What is strict mode in mysql?
How do I view mysql logs?
Explain the difference between procedure and function in mysql?
What is timestamp in mysql?
Is mysql same as sql?
Can we join 3 tables in mysql?