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

Veröffentlicht am: 08 August 2023
auf dem Kanal: 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

Auf dieser Seite können Sie das Online-Video SQL in Telugu - Case Statement/Expression with Examples || CASE in SQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer TeluguTechCoder 08 August 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 4,319 Mal angesehen und es wurde von 108 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

11,731

160