SQL Structure Query Language DDL CREATE ALTER DROP
- Slides: 52
���� SQL (Structure Query Language) ภาษานยามขอ มล (DDL) CREATE ALTER DROP 4 ภาษาจดการขอ มล (DML) SELECT UPDATE INSERT DELETE ภาษาควบคมข อมล (DCL) GRANT REVOKE
ระบหลายเงอนไขโดยใช โจทย >>สอบถามขอมลของลกคาทอย SQL 1 >> Ayuthaya SQL 2 >> 26 IN Bangkok, Rayong หรอ SELECT * FROM customer WHERE (C_address = ‘Bangkok’) OR (C_address = ‘Rayong’) OR (C_address = ‘Ayuthaya’) ; SELECT * FROM customer WHERE address IN (‘Bangkok’, ‘Rayong’ , ‘Ayuthaya’)
ระบหลายเงอนไขโดยใช โจทย SQL 1 >> สอบถามขอมลของลกคาทไมอยใน >> SQL 2 >> 27 NOT SELECT FROM WHERE * customer C_address <> ‘Bangkok’ ; SELECT FROM WHERE * customer NOT C_address = ‘Bangkok’; Bangkok
เลอกขอมลทอยในชวงทตองการดวย BETWEEN…AND โจทย >>แสดงชอของพนกงานทมเงนเดอนอยระหวาง และ 5, 000 บาท SQL 1 >> SQL 2 >> 29 SELECT FROM WHERE AND e_name employee (salary >= 3500) (salary <= 5000) ; SELECT FROM WHERE BETWEEN e_name employee salary 3500 AND 5000 ; 3, 500
โจทย ) ตองการทราบวา พนกงาน ทมรหสแผนก เขาอบรมหลกสตรใดบาง SELECT c_name FROM employee, training, course WHERE employee. dep_id = “dep 04” AND employee. em_id = training. em_id AND training. course_id = course_id 37 dep 04
ตวอยาง : ตองการทราบชอพนกงานทอยแผนกเดยวกบ SELECT em_name FROM employee WHERE dep_id IN ( SELECT em_name FROM employee WHERE em_name = “khanchai”) khanchai
เฉลย 1 SELECT em_name FROM employee WHERE dep_id = "dep 02"
ขอ 2 SELECT em_name FROM employee WHERE dep_id IN (SELECT dep_id FROM employee WHERE em_name =“นายเอกชย ใจเพชร") AND em_name != “นายเอกชย ใจเพชร"
ขอ 3 SELECT c_name FROM employee, training, course WHERE employee. em_name = "khanchai" AND employee. em_id=training. em_id AND training. course_id = course_id
ขอ 4 SELECT em_name FROM employee, training, course WHERE (c_name ="cooking") AND (training. em_id=employee. em_id) AND (training. course_id =course_id)
ขอ 5 SELECT em_name FROM employee, training WHERE employee. em_id = training. em_id AND (date BETWEEN “ 10/02/53" AND “ 11/02/53")
ขอ 6 SELECT em_name FROM employee WHERE em_name LIKE “ข%"
ขอ 7 SELECT * FROM employee WHERE em_name LIKE "%อก%"
- Name ddl commands create alter drop truncate
- Lir
- Introduction to structured query language (sql)
- Introduction to structured query language (sql)
- What does sql stand for
- A structured query language – sql operators are
- Sql stands for structured query language
- Structured query language (sql) is an example of a(n)
- Structured query language (sql) is an example of a(n)
- Sql nn
- Fungsi ddl
- Pl/sql ddl
- Dns recursive iterative
- Query tree and query graph
- Query tree and query graph
- Ddl structure
- Data description language
- Online query optimizer
- An attacker injects the following sql query blah
- Sqlstress
- Inside the sql server query optimizer
- Whoisactive sql query
- Sql queries for insert update and delete
- Shrpe
- Sql query
- Cosmos db query optimization
- Excel sql query
- Sql query for xml
- Sql server intelligent query processing
- Apa itu mutiple queue dan one way list
- Assertion in sql
- Oracle pl/sql create table
- Mysql create table if not exists example
- Sql create index statement
- Sql create ta
- Sql server create database
- Sql and plsql difference
- Pl sql unit test
- My structured query language
- Object query language
- Google visualization api query language
- Similar image search
- Linq guernsey
- Common query language
- Find the id name dept_name
- Google visualization playground
- Formal query language in dbms
- Relational query language
- Relational algebra and calculus
- Standardized query language
- Common query language
- Manhole drop structure
- Ddl base de datos