--Table create ho rhi
CREATE TABLE students (
id INT,
name VARCHAR(50),
age INT,
marks INT
);
-- Data insertion
INSERT INTO students VALUES
(1, 'Aditi', 20, 80),
(2, 'Manan', 21, 70),
(3, 'Namra', 20, 81),
(4, 'Shiva', 21, 78);
-- Fetching all the data
SELECT * FROM students;
-- Specific details
SELECT name , marks FROM students;
-- Condition
SELECT * FROM students
WHERE marks >= 60;
-- Arrangment of data
SELECT * FROM students
ORDER BY marks ASC;
SELECT 'LIMIT COMMAND' AS output;
SELECT * FROM students
ORDER BY age DESC
LIMIT 3;
To embed this project on your website, copy the following code and paste it into your website's HTML: