SDB101 » Select: Query 2
 
Query: List the names of the capital cities in the CITY table

SELECT * FROM CITY WHERE Capital ='Y'

Name
Country
Pop. (millions)
Capital
Shape
Havana
Cuba
2.1
Y
Point
Washington D.C.
USA
3.2
Y
Point
Brasilia
Brazil
1.5
Y
Point
Ottawa
Canada
0.8
Y
Point
Mexico City
Mexico
14.1
Y
Point
Buenos Aires
Argentina
10.75
Y
Point

Última modificación: Thursday, 17 de November de 2005, 17:12