drl – KTEXPERTS

Data Retrieval language(DRL)

Data Retrieval language(DRL) Data Retrieval Language (DRL) is a part of SQL used to retrieve (fetch) data from a database without modifying it. Main Command: SELECT – used to get data from one or more tables. Examples:

SELECT * FROM students;
→ Retrieves all records from the students table.

SELECT name, marks FROM students WHERE marks > 60;
→ Retrieves names and marks of students who scored more than 60.

SELECT * FROM students;

→ Retrieves all records from the students table.

SELECT name, marks FROM students WHERE marks > 60;

→ Retrieves names and marks of students who scored more than 60.

Purpose: ● To view data ● To… Read More

Data Definition Language (DDL)

7 hours ago by Kishor KumarSQL

Data Definition Language (DDL) Introduction Structured Query Language (SQL) is the standard language used for interacting with relational databases. SQL is divided into different categories based on the type of operations performed on the database. Among these categories, Data Definition Language (DDL) plays a foundational… Read More