select nid, prodname from products limit 0,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 / vigneshram

6 Answers
7427 Views
I also Faced
E-Mail Answers

Answer Posted / vigneshram

select nid, prodname from products limit 0,4

Is This Answer Correct ?

8 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we rollback truncate in mysql?

1021

Why is the basic difference between left join, right join and inner join?

1035

Can we write procedure in mysql?

950

How do I know if mysql is running on windows?

1095

Explain the difference between mysql and mysql interfaces in php?

1098

Which statement is used to delete a table in MySQL.

914

Is mysql an oracle product?

846

List the different types of normalization?

949

What is the hostname for mysql database?

1030

What is strict mode in mysql?

916

How do I view mysql logs?

891

Explain the difference between procedure and function in mysql?

996

What is timestamp in mysql?

987

Is mysql same as sql?

900

Can we join 3 tables in mysql?

963