Yevheniy Posted May 14, 2019 Share Posted May 14, 2019 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 More sharing options...
Funce Posted May 15, 2019 Share Posted May 15, 2019 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 More sharing options...
Rani Agrawal Posted July 2, 2019 Share Posted July 2, 2019 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 More sharing options...
Ingolme Posted July 4, 2019 Share Posted July 4, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now