Member Avatar for ramy2622

Can anybody ttell me the query for the question below, plz?

(a) Output the names of students and their addresses for those students who are living in Hunghom.

thx a lot~~~

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Inanna
Member Avatar for Inanna

The details depend on how you've set up your table, but something like this:

select name, address from MyTable where city = 'Hunghorn'

Or if you need to pick Hunghorn from the address itself:

select name, address from MyTable where address like '%Hunghorn%'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.