SQL में डेटा जॉइन करना
Maham Faisal Khan
Senior Content Developer, DataCamp
WHERE
WHERE IN
SELECT * FROM some_table WHERE some_numeric_field IN (4, 8, 12);
SELECT * FROM some_table WHERE some_field IN (include subquery here);
SELECT * FROM some_table WHERE some_field IN (SELECT some_numeric_field FROM another_table WHERE field2 = some_condition);
SELECT DISTINCT continent FROM states;
|---------------| | continent | |---------------| | Africa | | Asia | | Europe | | North America | | Oceania | |---------------|
SELECT DISTINCT continent, (SELECT COUNT(*) FROM monarchs WHERE states.continent = monarch.continent) AS monarch_count FROM states;
SELECT DISTINCT continent,
(SELECT COUNT(*) FROM monarchs
WHERE states.continent = monarch.continent) AS monarch_count FROM states;
| continent | monarch_count | |---------------|-----------------| | Africa | 0 | | Asia | 2 | | Europe | 2 | | North America | 0 | | Oceania | 0 |
Preparing Video For Download...
