SQL Queries for Student Details Management

The document contains SQL commands for managing a 'student_details' table. It includes queries to select all records, insert new student records, and retrieve column information from the table schema. Additionally, it shows an insertion of a new record with specific attributes for a female student named Priya.

Uploaded by

koulibalyhamam

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

4 views1 page

SQL Queries for Student Details Management

Uploaded by

koulibalyhamam

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

select * from student_details

insert into student_details

values ('Mayank','M',18,'2024-02-02',115.35),
('Mahesh','M',34,'2023-11-08',324.66)

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME like 'student_details'

insert into student_details (Student_Name,Gender)

values ('Priya','F')

select * from student_details

SQL: Joining Customers, Orders, Products
No ratings yet
SQL: Joining Customers, Orders, Products
1 page
Create Employees_US Table and Data
No ratings yet
Create Employees_US Table and Data
1 page
Average Salary in Finance Department
No ratings yet
Average Salary in Finance Department
1 page
Student Details Database Operations
No ratings yet
Student Details Database Operations
1 page
SQL Employee Data Manipulation Queries
No ratings yet
SQL Employee Data Manipulation Queries
1 page
SQL Server Employee Queries Guide
No ratings yet
SQL Server Employee Queries Guide
1 page
SQL Queries for Table Joins
No ratings yet
SQL Queries for Table Joins
1 page
SQL Queries for Table Joins
No ratings yet
SQL Queries for Table Joins
1 page
SQL Queries for Employee Filtering
No ratings yet
SQL Queries for Employee Filtering
1 page
Sales Analysis for Low-Performing Products
No ratings yet
Sales Analysis for Low-Performing Products
1 page
SQL Operations: Delete, Truncate, Drop
No ratings yet
SQL Operations: Delete, Truncate, Drop
1 page
SQL Union Queries Explained
No ratings yet
SQL Union Queries Explained
1 page
SQL Left and Right Anti Join Examples
No ratings yet
SQL Left and Right Anti Join Examples
1 page
Create and Populate Products Table
No ratings yet
Create and Populate Products Table
1 page
SQL Queries for Customer and Employee Data
No ratings yet
SQL Queries for Customer and Employee Data
1 page
SQL Database for Student Records
No ratings yet
SQL Database for Student Records
1 page
SQL Queries for Employee Records Analysis
No ratings yet
SQL Queries for Employee Records Analysis
1 page
Data Copying Between SQL Tables
No ratings yet
Data Copying Between SQL Tables
1 page
SQL Check Constraints Explained
No ratings yet
SQL Check Constraints Explained
1 page
SQL Queries for Employee Data Retrieval
No ratings yet
SQL Queries for Employee Data Retrieval
1 page
Default Constraints in SQL Tables
No ratings yet
Default Constraints in SQL Tables
1 page
Customer and Order Data Setup
No ratings yet
Customer and Order Data Setup
1 page

SQL Queries for Student Details Management

Uploaded by

SQL Queries for Student Details Management

Uploaded by

select * from student_details

insert into student_details

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME like 'student_details'

insert into student_details (Student_Name,Gender)

select * from student_details

You might also like