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
- 7622 Views
- I also Faced
- E-Mail Answers
Answer Posted / vigneshram
select nid, prodname from products limit 0,4
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How many triggers are possible in mysql?
What are the different tables present in MySQL?
Why do we use preparedstatement?
How do you use auto increment?
What is a select query?
What is mysql optimization?
How will you export tables as an xml file in mysql?
Who owns mysql database?
How to see the create table statement of an existing table?
How to show all tables with 'mysql'?
How we can get distinct columns values in mysql?
Can you tell how many values can set the function of mysql to consider?
What is field in mysql?
How many concurrent queries can mysql handle?
Describe mysql transaction properties.
