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
- 7428 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 do I find mysql version in mysql workbench?
What is the data type for file in mysql?
Which is better mysql or mssql?
How to delete the repeated records from a table?
What is the return type of mysqli_query?
Why use stored procedures in mysql?
What is key in mysql?
What is an example of a delimiter?
How do I run a query in mysql?
When to use order by in delete statement?
How do I declare a variable in mysql?
How database are managed?
How to returns the columns and column information pertaining to the designated table.
How can you retrieve a particular number of records from a table?
Why to use char instead of varchar in the database?
