(PDF) Types of SQL Statements

Added on - 29 Nov 2019

  • 13

    Pages

  • 559

    Words

  • 169

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 13 pages
Student IDStudent NameCourse IDInstructor Name
Table of ContentsQuery 1........................................................................................................................................................3Query 2........................................................................................................................................................4Query 3........................................................................................................................................................5Query 4........................................................................................................................................................6Query 5........................................................................................................................................................7Query 6........................................................................................................................................................8Query 7........................................................................................................................................................9Query 8......................................................................................................................................................10Query 9......................................................................................................................................................11Query 10....................................................................................................................................................12Query 11....................................................................................................................................................13
Before executing any of the Query please select the database ‘assignment5’ by executing the belowcommand:use assignment5;Query 1Show sums of line totals for each invoice.SQL StatementSELECT INV_NUMBER, ROUND(SUM(LINE_TOTAL), 2) AS SUMFROM lineGROUP BY INV_NUMBER;Result
Query 2Locate the record in the vendor table that does not have a value for the attribute V_STATESQL StatementSELECT * FROM vendorWHERE V_STATE IS NULL;Result
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document