KEMBAR78
Ronald Jay U. Ibina 11 - Tesla: Select Distinct From Update SET Where Create | PDF
Scribd
Upload
28 views2 pages

Ronald Jay U. Ibina 11 - Tesla: Select Distinct From Update SET Where Create

The document discusses different SQL data types, syntax, and flow chart symbols. It instructs the reader to research SQL numeric, date/time, character, and binary data types. It also lists SQL syntax for SELECT, UPDATE, CREATE TABLE, and DELETE statements. Finally, it provides examples of common flow chart symbols like start/end, action, decision, loop, and data storage symbols and instructs the reader to research what a flow chart is.

Uploaded by

Rjay Ibina
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
28 views2 pages

Ronald Jay U. Ibina 11 - Tesla: Select Distinct From Update SET Where Create

The document discusses different SQL data types, syntax, and flow chart symbols. It instructs the reader to research SQL numeric, date/time, character, and binary data types. It also lists SQL syntax for SELECT, UPDATE, CREATE TABLE, and DELETE statements. Finally, it provides examples of common flow chart symbols like start/end, action, decision, loop, and data storage symbols and instructs the reader to research what a flow chart is.

Uploaded by

Rjay Ibina
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/ 2

Ronald Jay U.

Ibina 11 – Tesla

Assignment 3
1. Search the different data types of SQL.
SQL Numeric Data Types
SQL Date and Time Types
SQL Character and String Data Types
SQL Unicode Character and String Data Types
SQL Binary Data Types
SQL Miscellanous Data Types
2. Search the different SQL syntax of the ff. (SELECT,UPDATE,CREATE
TABLE,DELETE)
SELECT DISTINCT column1, column2, ...
FROM table_name;

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

CREATE TABLE table_name (


column1 datatype,
column2 datatype,
column3 datatype,
....
);

DELETE FROM table_name WHERE condition;


3. Search what is Flow chart and the different symbols of flow chart.
Flow Chart is a diagram of the sequence of movements or actions of people or things
involved in a complex system or activity.
Flow Chart Symbols:
Start/End Symbol Merge Symbol
Action or Process Symbol Collate Symbol
Document Symbol Sort Symbol
Multiple Documents Symbol Subroutine Symbol
Decision Symbol Manual Loop Symbol
Input/Output Symbol Loop Limit Symbol
Manual Input Symbol Delay Symbol
Preparation Symbol Data Storage or Storage Data Symbol
Connection Symbol Database Symbol
Or Symbol Internal Storage Symbol
Summoning Junction Symbol Display Symbol
Off Page
.

You might also like