Non-Correlated Subqueries II

Language Help SQL
1

This subquery in example code in Learn section return empty results, because fac_type column in airports TABLE contains airport type without underscore sign “_”

    SELECT code 
    FROM airports 
    WHERE fac_type = 'SEAPLANE_BASE';

This requests is correct:

    SELECT code 
    FROM airports 
    WHERE fac_type = 'SEAPLANE BASE';

or

    SELECT code 
    FROM airports 
    WHERE fac_type LIKE 'SEAPLANE_BASE';

But in total it doesn’t matter. There are no flights from SEAPLANE BASE airports.

2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.