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
- 7163 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil alpati
No need to adding offset value. since your question says starting from first 4 records
Below is my query -
select nid, prodname from products limit 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to update info already in a table and delete a row(s) from a table.
What is the use of count function in mysql?
What is truncate command?
change column name and make a unique column so we get no dupes.
What is delimiter $$?
What is the command used to create a database using php and mysql?
Do I need python for mysql?
How can you find out the version of the installed mysql?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is the difference between mysql and pdo?
How do I kill a mysql connection?
How do I stop a mysql command?
Is mysql port 3306 tcp or udp?
How do I switch users in mysql?
Can you tell the difference between $message and $$message?
