Revising the Select Query I
Revising the Select Query I
+ 0 comments Please try the below mysql code :
SELECT * FROM CITY WHERE COUNTRYCODE = "USA" AND POPULATION > 100000;
+ 0 comments SET SERVEROUTPUT ON DECLARE CURSOR ISHI IS SELECT * FROM CITY WHERE POPULATION>=100000 AND COUNTRYCODE='USA'; DIS CITY%ROWTYPE; BEGIN OPEN ISHI; LOOP FETCH ISHI INTO DIS; EXIT WHEN ISHI%NOTFOUND; DBMS_OUTPUT.PUT_LINE(DIS.ID||' '||DIS.NAME||' ' ||DIS.COUNTRYCODE||' '||DIS.DISTRICT||' '||DIS.POPULATION); END LOOP; CLOSE ISHI; END; /
+ 0 comments SET SERVEROUTPUT ON DECLARE CURSOR ISHI IS SELECT * FROM CITY WHERE POPULATION>=100000 AND COUNTRYCODE='USA'; DIS CITY%ROWTYPE; BEGIN OPEN ISHI; LOOP FETCH ISHI INTO DIS; EXIT WHEN ISHI%NOTFOUND; DBMS_OUTPUT.PUT_LINE(DIS.ID||' '||DIS.NAME||' ' ||DIS.COUNTRYCODE||' '||DIS.DISTRICT||' '||DIS.POPULATION); END LOOP; CLOSE ISHI; END; /
+ 0 comments Certainly! Here is the SQL query in markdown format:
CREATE INDEX idx_population ON city(population); CREATE INDEX idx_countrycode ON city(countrycode); SELECT * FROM city WHERE population > 100000 AND countrycode = "USA";
+ 0 comments select * from CITY where POPULATION>100000 and COUNTRYCODE="USA";
Sort 683 Discussions, By:
Please Login in order to post a comment