SELECT prodid, prodname FROM products limit 4;

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

Question Posted / surya prakash

6 Answers
7616 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Is mysql open source?

1015

How to include character strings in sql statements?

1041

How to create a test table in your mysql server?

1100

Is mysql a nosql database?

1213

What is difference between mysql and mysql server?

1035

How do I delete a row in mysql?

1023

What is definer in mysql trigger?

973

How to create trigger in mysql phpmyadmin?

1182

How to enable or disable a row of a table using MySQL in struts?

4147

What is the purpose of using ifnull() function?

1043

How do you rename a procedure in mysql?

985

What is row?

1142

Why should I learn mysql?

965

What is the use of procedure in mysql?

975

Can we rename database in mysql?

1000