SQL Programs for Class 12 to B.Tech

Practical SQL Programs

Programs

-- 1. Create and populate
CREATE TABLE emp(id INT PRIMARY KEY, name VARCHAR(40), dept VARCHAR(20), salary INT);
INSERT INTO emp VALUES (1,'Aman','IT',50000),(2,'Riya','HR',45000);

-- 2. Department-wise average salary
SELECT dept, AVG(salary) FROM emp GROUP BY dept;

-- 3. Highest paid employee
SELECT name FROM emp ORDER BY salary DESC LIMIT 1;

-- 4. Give everyone a 10% raise
UPDATE emp SET salary = salary * 1.10;

-- 5. Employees above average salary
SELECT name FROM emp WHERE salary > (SELECT AVG(salary) FROM emp);

Summary

• Covers CREATE, INSERT, GROUP BY, ORDER/LIMIT, UPDATE and subqueries.
• These patterns appear in most practical exams.

Practical SQL Programs

Programs

-- 1. बनाएं और भरें
CREATE TABLE emp(id INT PRIMARY KEY, name VARCHAR(40), dept VARCHAR(20), salary INT);
INSERT INTO emp VALUES (1,'Aman','IT',50000),(2,'Riya','HR',45000);

-- 2. Department-wise average salary
SELECT dept, AVG(salary) FROM emp GROUP BY dept;

-- 3. सबसे ज़्यादा salary वाला
SELECT name FROM emp ORDER BY salary DESC LIMIT 1;

-- 4. सबको 10% raise दें
UPDATE emp SET salary = salary * 1.10;

-- 5. average से ज़्यादा salary वाले
SELECT name FROM emp WHERE salary > (SELECT AVG(salary) FROM emp);

सारांश

• CREATE, INSERT, GROUP BY, ORDER/LIMIT, UPDATE और subqueries cover करता है।
• ये patterns ज़्यादातर practical exams में आते हैं।