Scribd
Upload
85 views12 pages

Database Lab Assignment # 2

The document is a student assignment submission covering SQL concepts. It lists SQL topics like creating tables, selecting data, using where clauses, joins, aggregation, and stored procedures. It includes the student's name, registration number, section, and the instructor it is being submitted to.

Uploaded by

Chachu-420
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
85 views12 pages

Database Lab Assignment # 2

The document is a student assignment submission covering SQL concepts. It lists SQL topics like creating tables, selecting data, using where clauses, joins, aggregation, and stored procedures. It includes the student's name, registration number, section, and the instructor it is being submitted to.

Uploaded by

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

SAIFULLAH FA20-BCS-077 SECTION_B

11/06/2022

Assignment # 2
Name: Saifullah

Registration #: FA20-BCS-077

Section: B21-B

Submitted to:
Mam Sania Dilshad
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

Create database

 Create table

 Select
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Select Distinct

 Where

 AND or OR
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Order by

 Insert into

 Update
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Select Top

 Min & Max

 Select count,avg and sum


SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Select like

 Wildcards
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Between

 Aliases
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Full outer join


 Left and Right joins


SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022

 Self joins


 Unions


 Group by
SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022


 Exists (sub Query)

 Any and All


SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022


 Select into (backup)

 Insert into select


SAIFULLAH FA20-BCS-077 SECTION_B
11/06/2022


 Stored procedure

You might also like