Jump to content

SQL tutorial. Correction suggestion


Yevheniy

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.

Link to comment
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.

Link to comment
Share on other sites

  • 1 month later...

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;

Link to comment
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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...