Cities having Summer Temperature More than Jaipur in SQL

Cities having Summer Temperature More than Jaipur

 Write a query to display all the town names which has summer temperature more than “JAIPUR”. Output should be sorted on town name.

Cities having Summer Temperature More than Jaipur in SQL
Cities having Summer Temperature More than Jaipur in SQL

SQL Code: Cities having Summer Temperature More than Jaipur Solution

select townname from town t
where t.summertemp>(select summertemp from town where townname='JAIPUR')
order by 1;

Related:

Leave a Comment

10 − 10 =