Scribd
Upload
46 views13 pages

Experiment No.1 Implement DDL Command

The document outlines 10 SQL experiments covering DDL, DML, DQL commands and functions like aggregate, order by, between, like, group by, having. It also includes experiments on updating multiple records with one statement, selecting the second highest and lowest values, and displaying names starting with the letter "m".

Uploaded by

PROFESSIONAL SOUND
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
46 views13 pages

Experiment No.1 Implement DDL Command

The document outlines 10 SQL experiments covering DDL, DML, DQL commands and functions like aggregate, order by, between, like, group by, having. It also includes experiments on updating multiple records with one statement, selecting the second highest and lowest values, and displaying names starting with the letter "m".

Uploaded by

PROFESSIONAL SOUND
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Experiment no.

1
Implement DDL Command
DDl commands are:-
1.Create Command: -

2.Alter command:-
3.Truncate Command:-

4.Drop Command:

Experiment no.2
Implement DML Command:
DML commands are:-

1.Insert Command:-

2.Update Command:-

3.Delete Command:-
Experiment no.3
Implements DQl commands
1.select command:-
Experiment no.4
Create a DB and specify Primary and Foreign keys
1.Primary key:-

2.Foreign key:-
Experiment no.5
Implement Aggregate function
Aggregate Functions are:-

1.SUM:-

2.Min:-

3.Max:-
4.Avg:-

5.Count:-
Experiment no.6
Implement Order By,Between,Like,Group By and Having
1.Order By:-

2.Like:-

3.Group by:
4.Having:-

4.Between:-
Experiment no.7
Write query to display alternate rows(even or odd)
1.Even rows:-

2.Odd rows :-
Experiment no.8
Write query to Update multiple record by using one Update
statement
Experiment no.9
Write a query to select Second highest and lowest assets
Highest assets:-

Lowest assest:-
Experiment no.10
Write a query to display the name which start with the
alphabet “m”’;

You might also like