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
Answer Posted / surya prakash
SELECT prodid, prodname FROM products limit 4;
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can you rename a database in mysql?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How to use 'mysql' to run sql statements?
What is text?
How many ways to get the current time?
Who developed mysql?
What is the function of mysqldump?
What is the query to display top 20 rows?
How can you handle the –secure-file-priv in mysql?
What is full text indexing in mysql?
How can you make a database as your current database?
Describe mysql transaction properties.
What is mysql routine?
What is mvcc in mysql?
How do we delete a row in a table?