SELECT * means "Select everything." Use it sparingly in large databases!
SQL isn't case-sensitive ( select is the same as SELECT ), but writing keywords in CAPS makes your code easier to read. SQL: with practice exercises, Learn SQL Fast
SELECT column1, column2 -- Which columns do you want? FROM table_name -- Which table are they in? WHERE condition -- How do you want to filter them? ORDER BY column1 DESC; -- How should the results be sorted? Use code with caution. Copied to clipboard 3. Practice Exercises To practice, imagine a table named : Department Engineering Engineering Exercise 1: The Basics SELECT * means "Select everything
Always end your statements with a ; to tell the database you're done. FROM table_name -- Which table are they in
Find all employees with a salary over 75,000, sorted from highest to lowest.
Get the names of all employees in the 'Engineering' department.
Yes, I would like to receive newsletters, information and promotions about Where Winds Meet from NetEase Games. I will be able to withdraw my consent at any time.
By clicking on Pre-register, I confirm that I am 12 years old or over and that I accept NetEase Games's Privacy Policy and Terms of Use.
