29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial

Поделиться
HTML-код
  • Опубликовано: 10 июн 2023
  • Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
    So what are you waiting for? Grab your coffee and let's get started!
    Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
    📚 SQL Practice Questions -
    codeera.netlify.app/sql-pract...
    🔶Create Employee Table
    codeera.netlify.app/wp-conten...
    🔶Insert Data into Employee Table
    codeera.netlify.app/wp-conten...
    Connect with us on different platforms
    ✅ Visit Our Website: codeera.netlify.app/
    ✅ Subscribe us on RUclips: / @codeera2020
    ✅ Follow us on Instagram: / codeera_
    ✅ Follow us on Telegram: t.me/joingroupCodeEra
    📌28-Conversion Functions in SQL| CAST VS CONVERT | STR_TO_DATE
    • 28-Conversion Function...
    📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...
    • 27-Date & Time Functio...
    📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()
    • 26-Numeric Functions i...
    📌25-String Functions in SQL
    • 25-String Functions in...
    📌24-Difference Between WHERE and HAVING CLAUSE in SQL
    • 24-Difference Between ...
    📌23-HAVING CLAUSE in SQL
    • 23-HAVING CLAUSE in SQ...
    📌22 -GROUP BY Clause in SQL
    • 22 -GROUP BY Clause in...
    📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN
    • 21-Aggregate Functions...
    📌20 -TOP Clause in SQL | FETCH FIRST Clause
    • 20 -TOP Clause in SQL ...
    📌19- LIMIT and OFFSET in SQL
    • 19- LIMIT and OFFSET i...
    📌18- ORDER BY Clause in SQL
    • 18- ORDER BY Clause in...
    ⭐Part 1:Top 9 SQL queries for interview -
    • Top 9 SQL queries for ...
    ⭐Part 2:Top 9 SQL queries for interview -
    • PART 2 : Top 9 SQL que...
    ⭐Top SQL Interview Question
    • Top SQL Interview Ques...
    ⭐Interview SQL Query On Joins
    • Interview SQL Query On...
    ⭐DBMS vs RDBMS
    • DBMS vs RDBMS | What i...
    ⭐SQL Query To Swap Value Of Male and Female In Single Statement
    • SQL Query To Swap Valu...
    #sql
    #sqlcourse
    #sqlforbeginners
    #string
    #strings
    #stringfunctions
    #datamanagement
    #database
    #sqltraining
    #sqltutorial
    #dataanalytics
    #dataanalysis
    #learnsql
    #sqlqueries
    #sqlprogramming
    #onlinelearning
    #techskills
    #elearning
    #onlinetraining
    #programming
    #sql
    #having
    #sqlhavingclause
    #groupbyclause
    #sqlgroupbyclause
    #sqlselectcommand
    #LearnCoding
    #coding
    #careerdevelopment
    #beginners
    #MySQL
    #databasemanagement
    #DBMS
    #techtutorials
    #sqlforbeginners
    #sqltutorial
    #sqlcourse
    #sqltraining
    #simplilearn
    #sqlintroduction
    #sqlfullcourse
    #oracledatabase
    #oracle
    #oraclesql
    #ask4help
    #learncodin
    #clause
    #sqlserver
    #top
    #sqlqueries
    #sqloperators
    #setoperators
    #sqlsetoperators
  • НаукаНаука

Комментарии • 26

  • @ugonmaajie2240
    @ugonmaajie2240 7 месяцев назад

    You made it simple and clear. Thank you. 😊

  • @ezgikarayaka6290
    @ezgikarayaka6290 10 месяцев назад

    Awesome content, than you so much. So clear

  • @habibpatoana2931
    @habibpatoana2931 12 дней назад

    Thanks! Mam, Excellent

  • @bhumikakanwar6028
    @bhumikakanwar6028 Месяц назад +1

    Thank you mam very well explained ☺️😊

  • @santoshtandale8964
    @santoshtandale8964 Месяц назад

    you explained very well.. Thank you 👍

  • @ganeshsarade9108
    @ganeshsarade9108 6 месяцев назад

    Teaching style is very effective thank you so much 😊

  • @mr_psychic
    @mr_psychic 3 месяца назад

    Very well explained❤

  • @guljebapathan
    @guljebapathan 2 месяца назад

    Thanks ❤

  • @guljebapathan
    @guljebapathan 2 месяца назад

    Thank you ma'am ....❤ < very helpful ane easy video >

  • @vaibhavshinde8197
    @vaibhavshinde8197 7 месяцев назад

    Thank you so much mam☺☺

  • @jaymahajan3871
    @jaymahajan3871 Год назад

    Good 👍😊👍

  • @IBPS1234SO
    @IBPS1234SO Год назад +1

    Nice

  • @yashshrivastava7541
    @yashshrivastava7541 2 месяца назад

    The "except" and "minus" both are not working in Mysql Workbench 8.0. how to overcome this problem??

  • @satyareddy8671
    @satyareddy8671 Год назад +1

    Super

  • @vijay_madane03
    @vijay_madane03 2 дня назад

    Except is not working in SQL workbench please reply.

  • @BKYADAV-zm7yv
    @BKYADAV-zm7yv 4 месяца назад

    in your MySQL these all command are working why not in mine ?

  • @user-fl3it9pn9e
    @user-fl3it9pn9e Год назад +4

    Don't have any SQL practice questions on set operators, if possible please provide a link, madam... I'm following your channel regular bases.. thank you

    • @CodeEra2020
      @CodeEra2020  Год назад +1

      We have updated sql practice question.. Please check.

  • @akshaygangwani9875
    @akshaygangwani9875 25 дней назад

    how to insert union data into a new table?

  • @Mehedihasan-rahat
    @Mehedihasan-rahat 3 месяца назад

    Are column names should be the same as on screen???

  • @raghavindersirkha6563
    @raghavindersirkha6563 9 месяцев назад

    There is no scripts for manager table creation and insertion madam

  • @Sanjanaudemkadi
    @Sanjanaudemkadi 8 месяцев назад

    Why we use *

    • @CodeEra2020
      @CodeEra2020  8 месяцев назад

      In order to fetch all the columns of a table.

  • @user-ks6mj3kl7v
    @user-ks6mj3kl7v 5 месяцев назад

    Hii