0% found this document useful (0 votes)
4 views1 page

Database Views Post Invoice Discount Net Sales

Uploaded by

joneltmphqmi5
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
0% found this document useful (0 votes)
4 views1 page

Database Views Post Invoice Discount Net Sales

Uploaded by

joneltmphqmi5
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

/codebasics

COURSE SQL Advanced: Top Customers, Products,


TITLE Markets

CHAPTER
TITLE
Database Views: Post Invoice Discount, Net Sales

1 One cannot directly add the derived column in the


base query hence, CTEs, Sub Queries, or Views are
required.

2 It is possible to create multiple views out of the


base table.

You might also like