• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fetching first 5 values against every value in another column in another table

#1
Hi guys, hope this is the right section for this question.
I have 2 tables, topics (topic_id - pk) and comments (comment_id - pk, topic_id - fk). For all the topics, I want to get first 5 comment IDs in one go. Can you give me insights into how to go about it please?
Constantly learning.
Reply

#2
Use a join and limit the select to 5
Reply

#3
also you can add 'order by comment_id ASC' (i.e ascending order of comments)
Reply

#4
You answer may be using a combination of GROUP_CONCAT and FIND_IN_SET:

https://stackoverflow.com/questions/2129...-per-group
Reply

#5
(07-26-2017, 06:30 PM)skunkbad Wrote: You answer may be using a combination of GROUP_CONCAT and FIND_IN_SET:

https://stackoverflow.com/questions/2129...-per-group

Thanks! Will try this out
Constantly learning.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2017 MyBB Group.