Forum buat anak 09-2
 
IndeksPendaftaranLogin

Share | 
 

 T051 - Agregat

Go down 
PengirimMessage
jake

avatar

Jumlah posting : 7
Join date : 27.06.09
Age : 28
Lokasi : BSD(Bumi Serpong Damai) Tangerang

PostSubyek: T051 - Agregat   Sun Jul 26, 2009 6:43 pm

1. shortcut sql = sqlwb
2. perbedaan sql dan mysql = mysql adalah program database server
sedangkan sql adalah bahasa yang digunakan didalamnya. (lum yakin)
3. perbedaan where dan join?
Kembali Ke Atas Go down
https://www.facebook.com/jakeekel
jake

avatar

Jumlah posting : 7
Join date : 27.06.09
Age : 28
Lokasi : BSD(Bumi Serpong Damai) Tangerang

PostSubyek: Re: T051 - Agregat   Sun Jul 26, 2009 7:17 pm

3. (help me translate.tapi ini masih pengertiannya sih )

join =
An SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOINs: INNER, OUTER, LEFT, and RIGHT. In special cases, a table (base table, view, or joined table) can JOIN to itself in a self-join.

A programmer writes a JOIN predicate to identify the records for joining. If the evaluated predicate is true the combined record is then produced in the expected format, for example a record set or a temporary table.

where=
clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet a specified criteria. The criteria is expressed in form of predicates. WHERE clauses are not mandatory clauses of SQL DML statements, but should be used to limit the number of rows affected by a SQL DML statement or returned by a query.WHERE is an SQL reserved word.
Kembali Ke Atas Go down
https://www.facebook.com/jakeekel
 
T051 - Agregat
Kembali Ke Atas 
Halaman 1 dari 1

Permissions in this forum:Anda tidak dapat menjawab topik
Trainee 092 :: Pertanyaan-Pertanyaan Presentasi-
Navigasi: