Jump to content
Sign in to follow this  
Yevheniy

SQL tutorial. Correction suggestion

Recommended Posts

https://www.w3schools.com/sql/sql_distinct.asp

The following line: "The following SQL statement selects all (and duplicate) values from the "Country" column in the "Customers"" would be better understood if put this way:

"The following SQL statement selects all (including the duplicates) values from the "Country" column in the "Customers" 

The suggested correction is underlined.

Share this post


Link to post
Share on other sites

Try using the 'Report Error' button at the bottom of the page you've linked. Include what you've said here.

That will alert the developers to your correction.

Share this post


Link to post
Share on other sites

when trying to run below mention query in SQL editor provided by W3 schools, a query is not giving expected results under "SQL Aliases" section

Please copy paste the SQL query

SELECT CustomerName, Address + ', ' + PostalCode + ' ' + City + ', ' + Country AS Address
FROM Customers;

Share this post


Link to post
Share on other sites

I'd have to check the references again, but I don't think that SQL has a concatenation operator, "+" is for addition. MySQL uses the CONCAT() function to concatenate strings.

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...