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
Is mysql same as sql?
Is mysql relational?
What are the 3 main types of search queries?
Why we use mysql workbench?
What is bdb (berkeleydb)?
How is mysql database stored?
Can we create table in stored procedure?
How to get a list of columns in an existing table?
Where does mysql store data?
how to Return total number of rows.
What is difference between mysql mysqli and pdo?
How can we encrypt and decrypt a data presented in a table using mysql?
Where is the mysql data directory?
What is a user defined variable?
Is mysql case-sensitive?