A personal curation of commands that I found worth noting.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 

4 lines
487 B

SELECT [DISTINCT] firstName, lastName FROM members WHERE height > 170 AND (age % 2 = 0 OR age = 33); /* returns [unique] values of columns 'firstName' & 'lastName' from the table 'members', for people higher than 170 and with an even age or exactly 33y/o. */
SELECT CONCAT("there are ", COUNT(col), " of these") FROM TABLE WHERE col IN ("x", "y") AND NOT = "z"; /* pseudo query demonstrating `CONCAT` and `IN`. */
SUBSTRING(city, 1, 1) /* function returns first letter of `city`. */