Select by ID

Problem Statement

Given a City table, whose fields are described as

 

+-------------+----------+
| Field       | Type     |
+-------------+----------+
| ID          | int(11)  |
| Name        | char(35) |
| CountryCode | char(3)  |
| District    | char(20) |
| Population  | int(11)  |
+-------------+----------+

you have to print all the details of the city with ID is 1661.

Solution

  
Select * from City where ID = '1661'; 

\

Leave a Reply