SQL Basics

SQL Basics: Creating a Student Table

Creating the Student Table

        
CREATE TABLE Student (
    roll INT PRIMARY KEY,
    registration VARCHAR(10) UNIQUE,
    name VARCHAR(50),
    parents VARCHAR(100),
    class VARCHAR(20)
);
        
    

Querying the Entire Table

        
SELECT * FROM Student;
        
    

Output:

roll	registration	name	parents	class
101	2023A001	Rahul Sharma	Sunita Sharma	10A
102	2023A002	Priya Verma	Vijay Verma	9B

Querying Students by Name

        
SELECT * FROM Student WHERE name = 'Rahul Sharma';
        
    

Output:

roll	registration	name	parents	class
101	2023A001	Rahul Sharma	Sunita Sharma	10A

Querying Students by Roll

        
SELECT * FROM Student WHERE roll = 102;
        
    

Output:

roll	registration	name	parents	class
102	2023A002	Priya Verma	Vijay Verma	9B

Querying Students by Registration and Year

        
SELECT * FROM Student WHERE registration = '2023A001' AND class LIKE '10%';
        
    

Output:

roll	registration	name	parents	class
101	2023A001	Rahul Sharma	Sunita Sharma	10A