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 / surya prakash
SELECT prodid, prodname FROM products limit 4;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Does mysql use t sql?
What ascii 31?
What is ISAM?
How can you retrieve a particular number of records from a table?
What are the functions of mysql?
What are ddl statements in mysql?
How you can create a trigger in mysql?
What are the differences between a primary key and foreign key?
What is pragma serially_reusable and why is it used?
What is striped backup
What does it mean to be case sensitive?
What is a trigger? How you can create a trigger in mysql?
How to Change a users password from unix shell.
How to include character strings in sql statements?
How to rename an existing table in mysql?