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


Please Help Members By Posting Answers For Below Questions

Can we rename database in mysql?

491


How to get data from mysql in php?

438


How to insert dynamic values in mysql using php?

539


What are views in mysql?

521


Tell us something about heap tables?

556






What is bdb (berkeleydb)?

539


How many types of indexes are there in mysql?

484


Why we use mysql workbench?

475


What does innodb stand for?

531


What is the full meaning of mysql?

491


What is a string in mysql?

469


What is the usage of "i-am-a-dummy" flag in mysql?

677


Is mysql same as sql?

491


How many columns is too many mysql?

477


How can you take the backup and restore a mysql database using php?

484