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
- 5709 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 are mysql timestamps seen to a user?
What is a join? Explain the different types of mysql joins.
Is blocked because of many connection errors mysql?
When to use order by in delete statement?
How much does mysql cost?
Why do gaps in sequences occur?
What are the advantages and disadvantages of using mysql?
What is the use of mysql_fetch_array () function in php?
How to include numeric values in sql statements?
What are the different data types in mysql?
How do I download mysql on my laptop?
What is the difference between mysql and oracle?
How can you handle the –secure-file-priv in mysql?
How do I zip a file in mysql?
Can mysql and mariadb coexist?
