Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 7312 Views
- I also Faced
- E-Mail Answers
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
How to filter data from a mysql database table with php?
What is MySQL?
What are mysql functions?
How do I export mysql query results to excel?
What is flush privileges in mysql?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
Explain triggers and stored procedures?
What are the advantages of myisam over innodb?
What is the difference between truncate and delete in mysql?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Which command is used to view the content of the table in mysql?
What is the difference between mysql and oracle?
How many mysql connections can handle?
What is slow query log in mysql?
What is the password of mysql?
