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
- 7414 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
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How to get the current date in mysql?
How to see table's field formats or description of table .
How do I backup mysql database on linux?
Why mysql is open source?
What's the latest version of mysql?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What are the advantages of myisam over innodb?
What is processlist in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
How we can see all indexes defined for a table in mysql?
How much does mysql cost?
Is there a free mysql?
Explain csv tables.
How set mysql root password?
