SQL query with SELECT COUNT() in SELECT - subquery example | |||||||||||
Would you please provide working example how to use SQL SELECT with COUNT() in SELECT query ? | |||||||||||
| |||||||||||
Hi, The subquery with "SELECT in SELECT" should look for example like this: SELECT item_name FROM items AS i WHERE i.available_pcs = (SELECT COUNT(*) FROM reserved_items AS r WHERE i.item_id = r.item_id ); | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |