sql

The SELECT statement is used to query the database and retrieve data that match the criteria. The SELECT statement has five main clauses to choose from. Format of the SELECT statement: SELECT [ALL | DISTINCT] column1[,column2] FROM [table1, table2] [WHERE "conditions"] [GROUP BY "column-list"] [HAVING "conditions] [ORDER BY "column-list" [ASC | DESC] ] Example: SELECT name, age, salary FROM employee WHERE age > 40; ALL and DISTINCT are keywords used to select either all (default) or the distinct or unique records in query results....

This is a note type post for personal reference. I am learning SQL right now and for the learning purpose, I chose two websites: SQL Course; SQLBolt; For awesome learning experience, my advice is to follow one of them according to your preference. This post is just a summary of those content. Also, if anyone wants to practice SQL, see Hackerrank’s SQL problem-set. This is still in the early stage. Any suggestions will be appreciated....