Fetch multiple records with LIMIT Clause

I want to fetch records from the same table in three set of slots by using LIMIT clause mysql php. Such as i have 10 records in my students table. And i have to fetch 5 times which students have age above 18 years old, then fetch 3 times who are old above 12 years. And last one who are 5 years old that will be fetched 2 times. 5+3+2=10

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.