Member Avatar for abhi10kumar

How I can group concat of ids with limit 2 and order by id desc? Means, need all the ids except first two ids in desc order.

select group_concat(id) as ids from private_tuition_teacher_pdf where client_id = 14 and teacher_id = 15 limit 2 order by id desc
Edited by pritaeas because: Moved to databases. Please try to post in the correct forum.
  • 2 Contributors
  • 1 Reply
  • 3K Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

Limit 2 won't skip the first two IDs. It will mean the query only returns 2 rows.
You do a subquery, selecting all IDs in ascending order limit 2 and then use the NOT IN selector to return the rest of the rows.
Depending on the size of your table that could have a performance affect though.
I've assumed client_id is the id you are referring to

select group_concat(id) as ids from private_tuition_teacher_pdf 
where 
client_id NOT IN (select client_id from private_tuition_teacher_pdf order by client id asc limit 2)
and client_id = 14 and teacher_id = 15 
order by id desc
limit 2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.