DATABASELAMA
01 Write SOL commands for statements (i) to (vi) and give output for SQL queries
(vii) to (x) on the basis of the table FAMILY:
N
Name
Female
Incom Occupatio
Members
Members
1
Mishra
8
67000 Service
Gupta
4
5
15000
Business
0
13
Khan
4
48000 Mixed
Chaddh 2
CY
12500 Business
8
0
5
Yadav
7
12000 Mixed
6
Joshi
11
4
11400 Service
0
TA
Maurya
6
45000 Farming
18
Rao
5
le
11000 Service
(i) To display the name of all those where Male members are more than 3.
Answers
Answer:
In the era where data is being generated in humongous amounts, there is a constant need to handle data in databases. Relational databases are one of the most popular databases, and SQL is the basis of relational databases. Therefore SQL skills are indispensable in most of the job roles. In this article on SQL Commands, I will discuss the top commands and statements that you need to understand in SQL.
The topics covered in this blog are mainly divided into 4 categories:
Data Definition Language(DDL) – Consists of commands which are used to define the database.
Data Manipulation Language(DML) – Consists of commands which are used to manipulate the data present in the database.
Data Control Language(DCL) – Consists of commands which deal with the user permissions and controls of the database system.
Transaction Control Language(TCL) – Consist of commands which deal with the transaction of the database.
Apart from the above commands, the following topics will also be covered in this article:
Explanation:
plz make me brainlist plz plz plz plz