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
- 7620 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 does php communicate with mysql?
What is blob in mysql?
Why do we write stored procedures?
What are mysql data types?
What is delimiter in mysql trigger?
How to delete a column and add a new column to database
What can you do with mysql?
What is tee command in mysql?
Can you tell which of the following where clauses is faster?
What is the limitation of mysql?
What sql does mysql use?
What is the difference between truncate and delete?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is data directory in mysql?
how to add a new column to an existing table?
