Категории

SQL Query To Swap Value Of Male and Female In Single Statement | Update Query | SQL Tutorial

Опубликовано: 09 Ноябрь 2021
на канале: CodeEra
9,429
161

In this video we will see the update query to swap all value of female denoted as 'f' and male denoted as 'm' in a single statement using CASE Function.

Please Like 👍, Share and Subscribe.

Join our Telegram Channel - https://t.me/joingroupCodeEra

⭐Wipro Interview Experience | Selected
   • Wipro Interview Experience | Wipro EL...  

⭐Infosys Interview Experience | Selected
   • Infosys Interview Experience | Interv...  

⭐Constraints In SQL | Part-I
   • Constraints  In SQL | Part-I | SQL In...  

⭐Constraints In SQL | Part-II
   • Constraints  In SQL | Part-|| | SQL I...  

⭐Find the number of Employees working in each department | SQL
   • Find the number of Employees working ...  

⭐Part 1:Top 9 SQL queries for interview -
   • Top 9 SQL queries for interview | SQL...  

⭐Part 2:Top 9 SQL queries for interview -
   • PART 2 : Top 9 SQL queries for interv...  

⭐Top SQL Interview Question
   • Top SQL Interview Question | Most Ask...  

#SQLInterviewQuestion
#SQLTutorial
#SQLQuery
#MySQL
#Oracle
#SQLServer
#ImportantInterviewQuestion
#SQLPracticeQuestions
#practice
#UpdateQuery
#MostImportantSqlQuery

play_arrow
10,383,735
46 тыс

ItaloBrothers - My Life Is A Party (R.I.O. Video Edit)

ItaloBrothers - My Life Is A Party (R.I.O. Video Edit)
play_arrow
47,830
191

Preview 2KC Center Effects Squared (^2) Tried To Be Normal

Preview 2KC Center Effects Squared (^2) Tried To Be Normal
play_arrow
3,570
17

KIDS- How to Draw a rabbit

KIDS- How to Draw a rabbit
play_arrow
2,104
15

Kuwa utakavyokuwa huu ndio MWISHO WAKO MWANADAMU

Kuwa utakavyokuwa huu ndio MWISHO WAKO MWANADAMU
play_arrow
64
4

DOWNLOAD 3D MODELS (living room) -3

DOWNLOAD 3D MODELS (living room) -3
play_arrow
4,381,793
135 тыс

Every Nazi Symbol Explained By a German

Every Nazi Symbol Explained By a German
play_arrow
36,724
622

00:00:00

РЕЖЬТЕ ПО МАКСИМУМУ! Как обрезать МЕТЕЛЬЧАТУЮ ГОРТЕНЗИЮ весной, если ей ВСЕГО ГОД ПОСЛЕ ПОСАДКИ

РЕЖЬТЕ ПО МАКСИМУМУ! Как обрезать МЕТЕЛЬЧАТУЮ ГОРТЕНЗИЮ весной, если ей ВСЕГО ГОД ПОСЛЕ ПОСАДКИ
play_arrow
5,501,694
15 тыс

СЕРИАЛ ТОЛЬКО ЧТО ВЫШЕЛ НА КАНАЛЕ! ВЫ ОБЯЗАНЫ ОЦЕНИТЬ! ЧТО ТВОРИТ СИЛА С КРАСОТОЙ! КРАСАВИЦА И ВОРЫ

СЕРИАЛ ТОЛЬКО ЧТО ВЫШЕЛ НА КАНАЛЕ! ВЫ ОБЯЗАНЫ ОЦЕНИТЬ! ЧТО ТВОРИТ СИЛА С КРАСОТОЙ! КРАСАВИЦА И ВОРЫ
Похожие видео
play_arrow
40 - Difference Between DELETE, DROP and TRUNCATE | SQL | Interview Question | Examples | DBMS

40 - Difference Between DELETE, DROP and TRUNCATE | SQL | Interview Question | Examples | DBMS
play_arrow
Latest Accenture Interview Experience 2023 |TOP Interview Questions & Answers | ASE | Interview Tips

Latest Accenture Interview Experience 2023 |TOP Interview Questions & Answers | ASE | Interview Tips
play_arrow
39 - ALTER Command in SQL | ALTER vs UPDATE | Add, Rename, Modify, Drop Column/Table | DDL Command

39 - ALTER Command in SQL | ALTER vs UPDATE | Add, Rename, Modify, Drop Column/Table | DDL Command
play_arrow
Accenture Latest Interview Experience 2023 |All Interview Questions & Answers | ASE | TR+HR | 4.5LPA

Accenture Latest Interview Experience 2023 |All Interview Questions & Answers | ASE | TR+HR | 4.5LPA
play_arrow
38-UPDATE Command In SQL | How To UPDATE Records In Table | DML Command | UPDATE Query With Example

38-UPDATE Command In SQL | How To UPDATE Records In Table | DML Command | UPDATE Query With Example
play_arrow
37-Subquery Using ALL,ANY & EXISTS Operators in SQL | Example | Advance SQL | EXISTS vs IN vs JOINS

37-Subquery Using ALL,ANY & EXISTS Operators in SQL | Example | Advance SQL | EXISTS vs IN vs JOINS
play_arrow
36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL

36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL
play_arrow
35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN

35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN
play_arrow
34-CROSS JOIN in SQL | Cartesian Product | How does it work | CROSS JOIN with MULTIPLE TABLES | SQL

34-CROSS JOIN in SQL | Cartesian Product | How does it work | CROSS JOIN with MULTIPLE TABLES | SQL
play_arrow
33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN | Types of JOINS | Examples| Interview Topic

33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN | Types of JOINS | Examples| Interview Topic
play_arrow
32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join | Interview Topic

32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join | Interview Topic
play_arrow
31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN |Practice SQL Query using JOINS |Example

31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN |Practice SQL Query using JOINS |Example
play_arrow
30-Introduction to Joins & its types | Need of Joins with example | Relational Tables | Joins Query

30-Introduction to Joins & its types | Need of Joins with example | Relational Tables | Joins Query
play_arrow
29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial

29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial
play_arrow
28-Conversion Functions in SQL | Types of SQL Functions| CAST VS CONVERT | STR_TO_DATE | DATE_FORMAT

28-Conversion Functions in SQL | Types of SQL Functions| CAST VS CONVERT | STR_TO_DATE | DATE_FORMAT
play_arrow
27-Date & Time Functions in SQL | Types of SQL Functions| Examples | DATE_FORMAT(), DATE_ADD(),etc..

27-Date & Time Functions in SQL | Types of SQL Functions| Examples | DATE_FORMAT(), DATE_ADD(),etc..
play_arrow
26-Numeric Functions in SQL | Types of SQL Functions | Examples | ABS(),MOD(),SQRT(),CEIL(),POWER()

26-Numeric Functions in SQL | Types of SQL Functions | Examples | ABS(),MOD(),SQRT(),CEIL(),POWER()
play_arrow
25-String Functions in SQL | Types of SQL Functions | Examples | SUBSTR(),CONCAT(),UPPER(),REVERSE()

25-String Functions in SQL | Types of SQL Functions | Examples | SUBSTR(),CONCAT(),UPPER(),REVERSE()
play_arrow
24-Difference Between WHERE and HAVING CLAUSE in SQL | Examples | Most Important Interview Question

24-Difference Between WHERE and HAVING CLAUSE in SQL | Examples | Most Important Interview Question
play_arrow
23-HAVING CLAUSE in SQL | Use Of HAVING | Interview Questions | Example| Single & Multiple Condition

23-HAVING CLAUSE in SQL | Use Of HAVING | Interview Questions | Example| Single & Multiple Condition
play_arrow
22 -GROUP BY Clause in SQL | Use Of GROUP BY | Interview Questions | Examples | Multiple Column| SQL

22 -GROUP BY Clause in SQL | Use Of GROUP BY | Interview Questions | Examples | Multiple Column| SQL
play_arrow
21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN | Important Interview Query | COUNT(*)

21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN | Important Interview Query | COUNT(*)
play_arrow
20 -TOP Clause in SQL | FETCH FIRST Clause | LIMIT vs TOP | SQL Practice Query | Oracle | SQL Server

20 -TOP Clause in SQL | FETCH FIRST Clause | LIMIT vs TOP | SQL Practice Query | Oracle | SQL Server
play_arrow
19- LIMIT and OFFSET in SQL | Find Nth highest salary using LIMIT Clause | Interview Question

19- LIMIT and OFFSET in SQL | Find Nth highest salary using LIMIT Clause | Interview Question