1. imagine there are 2 tables first table(personal table) consist of : name, age, official address, personal addresssecond table(address table) consist of : street, city, state, phone number, country, zip codeHere personal address and official points to address table1. create the above table2. find and goup the name of the person who lives in same zip code using personal addressIf somebody answer this, it would be a great help.

  • Interview Candidate
  • 1
  • 1389

Showing Answers 1 - 1 of 1 Answers

namita

  • May 12th, 2006
 

Table is not normalizedfirst we need to normalizedempid empname age officezip persozip102 bbb 24 zipc001 zipc002zipcode city street countryzipc001 pune shivaji nagar indiaselect * from table1 group by persozip;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions