SQL Interview Questions | Common Data

Question

Write a query for collecting the names of children who pursuing their graduation in their residential city.

NAME AGE ADDRESS COLLEGE
……. …… ….. …..

 

(Hint- Look for the common city name in the columns of ADDRESS and COLLEGE)

in progress 1
Dhruv2301 4 days 2 Answers 57 views Contributor 0

Answers ( 2 )

  1. Select name
    From table
    Where address.city=college.city

  2. Select Name
    From table
    where Address.city = College.city ;

Leave an answer

Browse
Browse