how to write the query for the following using regular db schema find street address, postal code, city and state for all the employees

Tags:
SQL
how to write the query  for the following using regular db schema
find street address, postal code, city and state for all the employees


Software/Hardware used:
sql
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Probably this is a homework or an assignment. You may write some code by your own, if the code will not run properly, then we can help to correct it.
    142,210 pointsBadges:
    report
  • carlosdl
    That is so basic, that if you are not able to do it by yourself, you really need to start over and take your learning a little more seriously.
    85,865 pointsBadges:
    report
  • ToddN2000
    We can't help you unless you post your code so we know the table name as well as the column names. We can point out your errors but you need to try it on your own to learn how to do it. We can't do it for the rest of your career. 
    136,290 pointsBadges:
    report
  • TheRealRaven
    Not only post any troublesome code, but also post the relevant DB structure. No query is possible and no critique is possible when the schema isn't defined.

    Given the originally posted 'question', it seems like a very simple basic SELECT statement.
    36,880 pointsBadges:
    report
  • ToddN2000
    Without additional info it's impossible to tell you.
    this would be a valid statement if the table and column names existed

    SELECT a,b,c,d,e from f
    WHERE a='X'

    Try writing and post back any error messages as well as the code and we can help you straighten it out.
    136,290 pointsBadges:
    report
  • Subhendu Sen
    Please take a look here for more help, https://www.w3schools.com/sql/
    142,210 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: