Jump to content
Sign in to follow this  
rose123

SQL Aliases Exercise

Recommended Posts

The exercise below asks for the answer AS Pno.  The only reason I know that is that I clicked on the show answer button.  My answer, was AS Zip, which is what we shorten Postal code to in the US.  I had never heard of Pno until today.  I couldn't even find that abbreviation on the web.  What I found was planned non-operation, which is a choice for type of vehicle registration here.  How was I supposed to get this correct?

 

SELECT CustomerName,
Address,
PostalCode 
FROM Customers;

Share this post


Link to post
Share on other sites

I can't see what the exercise actually was, but for learning purposes, the alias you use should not matter at all. Most likely it was the syntax that was incorrect.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...