We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 4
  5. Discussions

Weather Observation Station 4

Sort by

recency

|

1459 Discussions

|

  • nk18840
     + 0 comments

    SELECT COUNT(CITY) - COUNT(DISTINCT CITY) AS DIFFERENCE FROM STATION;

  • malhotrashaurya1
     + 0 comments
    set serveroutput on
declare 
v_no_1 number;
v_no_2 number;
BEGIN
select count(city) into v_no_1 from station;
select count(distinct city) into v_no_2 from station;
dbms_output.put_line(v_no_1-v_no_2);
end;

    /

  • guiller_zeva16
     + 0 comments

    SELECT SUM(COUNT() - 1) FROM STATION GROUP BY CITY HAVING COUNT() > 1;

  • anshuldayal5346
     + 0 comments

    Best Answer is: SELECT COUNT (CITY) - COUNT(DISTINCT CITY) FROM STATION;

  • CarolOwens78
     + 1 comment

    It’s always helpful when database logic is explained in a simple, real-world way. Really appreciate the clarity and the effort that went into this! Betinexchange 247.com