Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Test
SELECT order_item_line.* FROM order_item_line LEFT JOIN ( SELECT fk_o_id, GROUP_CONCAT(id) grouped_fk_o_id,id FROM order_item GROUP BY fk_o_id ) group_max ON order_item_line.fk_o_id = group_max.id and FIND_IN_SET(order_item_line.fk_o_id, grouped_fk_o_id) BETWEEN 2 AND 3
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
sort players by sum of results
mySQL Special Character Encoding
Mysql join same table where not in
My name is busy
ITM_14210069
Conditional SQL select
ventas
mysql - order by,limit,offset
calculate averages for students and levels
barbato
Please log in to post a comment.