Posts

Showing posts with the label SQL VIEWS

Featured Post

How to Compare Text in Python

Image
Python like other programming languages supports comparison operators. These primarily use to test the condition in the program. Here's a list of operators that you can use in python programs. Comparison operators List of operators < <= > >= == != Is is not How to use comparison operators Here, I have assigned 23 to a and 11 to b. Then, I did apply all the comparison operators. The output is self-explanatory, and If you are in doubt while programming, remember to visit this page. Examples a = 23 b = 11 print("Is a greater than b?", a > b)           #greater than print("Is a less than b?", a < b)              #less than print("Is a greater or equal to b?", a >= b)   #greater or equal print("Is a less or equal to b?", a <= b)      #less or equal print("Is a equal to b (option 1)?", a == b)         #test for equality print("Is a equal to b (option 2)?", a is b)         #test for equality print("I

3 SQL Query Examples to Create Views Quickly

Image
There are three kinds of Views in SQL. The three views are Read-only, Force, and Updatable. Views real usage is to hide data. And you need to ensure base tables are present before you create a View. You can call views as logical tables. The advantage of Views is you can show only some of the fields of base tables. What is a View in SQL A view can be constructed with another view so it is called a nested view. You can create or replace an existing view A view can be created without having base tables. This is possible with the FORCE option. #1: Read-Only Views The standard syntax for the view is as follows: CREATE OR replace VIEW invoice_summary AS SELECT vendor_name count(*) AS invoice_count, SUM(invoice_total) AS invoice_total_sum FROM vendor JOIN invoices ON vendors.vendor_id*invoices.vendor_id GROUP BY vendor_name; Notes: You cannot update Read-only Views #2: Force Views CREATE FORCE VIEW products_list AS SELECT product_description, product_price FROM products;