SQL

25. UNION https://www.w3schools.com/sql/sql_union.asp 26. Group by https://www.w3schools.com/sql/sql_groupby.asp 27. Having clause https://www.w3schools.com/sql/sql_having.asp 28. Exits operator https://www.w3schools.com/sql/sql_exists.asp

21. Left Join https://www.w3schools.com/sql/sql_join_left.asp 22. Right Join https://www.w3schools.com/sql/sql_join_right.asp 23. Full Join https://www.w3schools.com/sql/sql_join_full.asp 24. Self Join https://www.w3schools.com/sql/sql_join_self.asp

SQL Syntax list : 1,2. SELECT https://t.me/sql_syntax/3 3. SELECT DISTINCT https://t.me/sql_syntax/4 4. WHERE clause https://t.me/sql_syntax/5 5. AND, OR, NOT operators https://t.me/sql_syntax/7 6. ORDER BY ASC/DESC https://t.me/sql_syntax/12 Hi, I think it's will be much helpful if I could post link to website where u can read all this and practice as well.. So after order by syntax the remaining links will t…

Wish you all blissful and prosperous and very Happy New Year 🥳🥳🥳 I found this video as very helpful, for for streamlining my goals and habits and how to achieve them. Hope it helps you too.. 😊 Watch here 👇 https://youtu.be/PZ7lDrwYdZc

Hi Subscribers, Instead of posting new message every time we are just editing the above message and adding new syntaxs to list.. So don't miss out.. Great day !!! Tip: Weekend means extra time we have at hands not only to have fun with family and friends but also to contribute to self-improvement ( reading books, learning new skills and many more.. )

SQL related channels: Channel for SQL learning: @sql_res Chennal for SQL syntax: @sql_syntax Chennal for SQL interview questions: @etl_sql_interview

SQL Syntax list : 1,2. SELECT https://t.me/sql_syntax/3 3. SELECT DISTINCT https://t.me/sql_syntax/4 4. WHERE clause https://t.me/sql_syntax/5 5. AND, OR, NOT operators https://t.me/sql_syntax/7 6. ORDER BY ASC/DESC https://t.me/sql_syntax/12 Hi, I think it's will be much helpful if I could post link to website where u can read all this and practice as well.. So after order by syntax the remaining links will t…

6. ORDER BY Syntax SELECT column1, column2, ... FROM table_name ORDER BY column1, column2, ... ASC|DESC; The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword. Example: The following SQL statement selects all customers from the "Customers" table, sort…

Photo, posted without a caption

5. AND, OR and NOT Operators syntax AND Syntax SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...; The AND operator displays a record if all the conditions separated by AND are TRUE. Example: The following SQL statement selects all fields/columns/attributes (all are same meaning) from "Customers" where country is "Germany" AND city is "Berlin" SELECT * FROM Customers …

Here Customer_details is table name Customer_id, name, address, age are column names

4. WHERE Syntax SELECT column1, column2, ... FROM table_name WHERE condition; The SQL WHERE Clause The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition. WHERE Clause Example The following SQL statement selects all the customers from the country "Mexico", in the "Customers" table: Example SELECT * FROM Customers WHERE Country='Mexico' ;