Skip to content

Instantly share code, notes, and snippets.

View UtkarshYadav01's full-sized avatar

Utkarsh Yadav UtkarshYadav01

View GitHub Profile
-- MySQL DISTINCT Tutorial
-- The DISTINCT clause eliminates duplicate rows from the result set
-- Syntax: SELECT DISTINCT column1, column2 FROM table_name;
-- Create and use the database
CREATE DATABASE EmployeeDB;
USE EmployeeDB;
-- Create employees table
CREATE TABLE employees (
-- MySQL Aliases Tutorial
-- Aliases are temporary names assigned to database tables, columns, or expressions
-- to make them more readable and manageable.
-- Create and use the database
CREATE DATABASE db16;
USE db16;
-- Create employees table
CREATE TABLE employees (