logo

Query and Update Databases Using SQL

13 Pages275 Words39 Views
   

Charles Sturt University

   

Database Management Systems (ITECH 1006)

   

Added on  2020-03-01

About This Document

This document will discuss how to update databases using SQL and all the queries that can affect the implementation.

Query and Update Databases Using SQL

   

Charles Sturt University

   

Database Management Systems (ITECH 1006)

   Added on 2020-03-01

ShareRelated Documents
STUDENT DETAILS
Query and Update Databases Using SQL_1
1.QuerySELECT invoice.INV_TOTAL FROM invoice;2. QuerySELECT * FROM vendor WHERE vendor.V_STATE IS NULL;
Query and Update Databases Using SQL_2
3. QuerySELECT * FROM customer WHERE customer.CUS_BALANCE BETWEEN 200 and 300;
Query and Update Databases Using SQL_3
4.QuerySELECT customer.*,invoice.INV_TOTAL FROM customer INNER JOIN invoice ON customer.CUS_CODE=invoice.CUS_CODEHAVING invoice.INV_TOTAL>200;
Query and Update Databases Using SQL_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design: Assignment
|9
|404
|85

Assignment on Database Design System
|9
|396
|50

Sums of Line Totals for Each Lnvoice
|10
|450
|61

Database System Assignment - SQL Code
|17
|541
|99

Assignment on Database System
|17
|541
|50

Database Management System Assignment
|6
|232
|66