SQL query with SELECT COUNT() in SELECT - subquery example

Question

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 ?

0

Report

14 May 2021 at 05:56 PM

Stor

sql

1 answer

OK

Tim · Answer 1

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 );

SQL query with SELECT COUNT() in SELECT - subquery example

sql

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Fix error: mysqli_select_db / query expects 2 arguments, 1 given

Copy and update rows in the same table with autoincrement - SQL

Fix SQL error Index for table 'user_db' is corrupted, try to repair it

Insert or update current date in DATETIME format - SQL

MySQL error: Unknown table engine 'InnoDB' - how to fix ?