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
- 7317 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
What is not null in mysql?
How do I free up space in mysql?
What is the date format in mysql?
What is the difference between heap table and temporary table?
What is the default password for mysql?
How large can a mysql table be?
How to display top 50 rows?
What are date and time functions in mysql?
What are programming functions?
How to use sum function in where clause in mysql?
What are the advantages/disadvantages of mysql and php?
What is the insert?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How many columns can you create for an index?
Explain triggers and stored procedures?
