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
Is mysql open source?
How to include character strings in sql statements?
How to create a test table in your mysql server?
Is mysql a nosql database?
What is difference between mysql and mysql server?
How do I delete a row in mysql?
What is definer in mysql trigger?
How to create trigger in mysql phpmyadmin?
How to enable or disable a row of a table using MySQL in struts?
What is the purpose of using ifnull() function?
How do you rename a procedure in mysql?
What is row?
Why should I learn mysql?
What is the use of procedure in mysql?
Can we rename database in mysql?