SQL in Telugu - Case Statement/Expression with Examples || CASE in SQL

Pubblicato il: 08 agosto 2023
sul canale di: TeluguTechCoder

4,319

108

In this video, we walk through Case Statements explained with use case as well as using the UPDATE statement
➤ Join our Facebook group:
/ 206746378741662
➤ Join our WhatsApp group:
https://chat.whatsapp.com/JXrRh9IX0Gu...
➤ Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career to Data Analytics. Be sure to subscribe to not miss out on any content!

CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Salary DECIMAL(10, 2),
Department VARCHAR(50)
);

INSERT INTO Employees (EmployeeID, FirstName, LastName, Salary, Department)
VALUES
(1, 'John', 'Doe', 50000.00, 'HR'),
(2, 'Jane', 'Smith', 60000.00, 'IT'),
(3, 'Mike', 'Johnson', 55000.00, 'IT'),
(4, 'Lisa', 'Williams', 48000.00, 'HR'),
(5, 'Mark', 'Anderson', 62000.00, 'Sales'),
(6, 'Sarah', 'Lee', 56000.00, 'IT'),
(7, 'Michael', 'Brown', 51000.00, 'HR'),
(8, 'Emily', 'Johnson', 58000.00, 'Sales'),
(9, 'David', 'Miller', 47000.00, 'IT'),
(10, 'Michelle', 'Wilson', 52000.00, 'Sales'),
(11, 'Andrew', 'Thomas', 54000.00, 'IT'),
(12, 'Jessica', 'Martinez', 59000.00, 'HR'),
(13, 'Matthew', 'Taylor', 63000.00, 'IT'),
(14, 'Amanda', 'Clark', 48000.00, 'Sales'),
(15, 'Kevin', 'Walker', 57000.00, 'Sales'),
(16, 'Laura', 'White', 52000.00, 'HR'),
(17, 'Steven', 'Harris', 55000.00, 'IT'),
(18, 'Rachel', 'Jackson', 60000.00, 'IT'),
(19, 'Jason', 'Lewis', 49000.00, 'Sales'),
(20, 'Samantha', 'Allen', 51000.00, 'HR');

Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!

Subscribe Now and Stay Updated! 🔔
► Visit our website: https://visionforanalytics.com/
► Join our Facebook group: / 995887284773826

In questa pagina del sito puoi guardare il video online SQL in Telugu - Case Statement/Expression with Examples || CASE in SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato TeluguTechCoder 08 agosto 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,319 volte e gli è piaciuto 108 spettatori. Buona visione!

925