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
- 7408 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 memory table in mysql?
What is mysql in dbms?
How you can create a trigger in mysql?
Is mysql a database?
What is mysql default database?
What sql does mysql use?
Where is the myisam table stored?
How can an index be declared in mysql?
What are the advantages of MySQL when compared with Oracle?
What is 'mysqlshow'?
Is mysql a programming language?
What are the advantages of mysql in comparison to oracle?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
How would you get the current date in mysql?
Is mysql connect deprecated?
