- Select By ID

 Query all columns for a city in CITY with the ID 1661.

The CITY table is described as follows:

select * from city where id=1661;


Expected Output
  • 1661 Sayama JPN Saitama 162472
  • DB2, MySQL, Oracle, MS SQL Server

    SELECT * 
    FROM CITY 
    WHERE ID = 1661;

Post a Comment

Previous Post Next Post