Last active
January 19, 2024 17:24
-
-
Save pedroinfo/511877716ab492b64e1e5d053425a091 to your computer and use it in GitHub Desktop.
Case When Example - Vivi
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Use MyDb | |
GO | |
DROP TABLE IF EXISTS Tb_Funcionario | |
CREATE TABLE Tb_Funcionario | |
( | |
Id INT NOT NULL, | |
Nome VARCHAR(200), | |
DataNascimento DATE, | |
Classificacao CHAR | |
) | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (1, 'Vivian Oliveira', '1980-01-02', '7') | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (1, 'Pedro Xavier', '2000-01-02', '5') | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (2, 'Funcionario A', '1980-01-02', '7') | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (1, 'Funcionario B', '1999-01-02', '8 ') | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (1, 'Funcionario C', '1997-08-02', '7') | |
INSERT INTO Tb_Funcionario(Id, Nome, DataNascimento, Classificacao) VALUES (1, 'Funcionario D', '2000-01-02', '8') | |
SELECT Id, | |
Nome, | |
DataNascimento, | |
Classificacao AS 'ClassificacaoOriginal', | |
CASE WHEN Classificacao = '7' THEN 'A' | |
WHEN Classificacao = '8' THEN 'B' | |
ELSE 'Sem Classificação!' | |
END AS 'ClassificacaoModificada' | |
FROM Tb_Funcionario |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment