Recent Posts Tagged With 'sql'

• Menyisipkan Judul Report didalam Statement SQL

  Posted on Tuesday August 5th, 2008 at 23:55 in sql, delphi programming, delphi tips

  Inti dari tutorial ini adalah menunjukan bagaimana caranya menyisipkan string reguler didalam statement SQL. String reguler disini maksudnya adalah string yang bukan nilai dari sebuah table di dalam Database. Contoh : SELECT 'Daftar Produk (Seluruh)...

• SQL : Using subquery to resolving query problems

  Posted on Sunday July 13th, 2008 at 01:41 in sql, sql subquery

  When working with databases and records sometimes we find difficulties in displaying data from many tables using SQL join. For example you wish to include some aggregate columns from three tables below : the structure of the products table : Product...

• SQL BETWEEN: Searching Between Two Specified Values (Range)

  Posted on Sunday June 8th, 2008 at 21:23 in sql, sql between

  Syntax expression [ NOT ] BETWEEN lower_value AND higher_value The SQL BETWEEN Operator are used to display rows between two specified values. The lower value are placed before AND operator and the higher value are placed after AND operator. For Ex...

• Using SQL Outer Join

  Posted on Sunday June 8th, 2008 at 21:21 in sql, sql outer join

  When you use SQL JOIN/INNER JOIN, the result are rows that only matches in both table based on Join condition you specified in the FROM clause. If you need to display all rows from at least one of the tables mentioned in the FROM clause, you can use ...

• SQL JOIN : Retrieving Data from many Tables

  Posted on Sunday June 8th, 2008 at 21:17 in sql, sql join

  Joins are created when we display Data in queries that using more than one tables. we can connect a row in one table to another row in other table using the same value of both rows. Usualy this relation represented as Primary Key and Foreign Key rela...

• Sorting Data Using SQL Like Operator

  Posted on Thursday March 27th, 2008 at 04:28 in sql

  Operator Like digunakan dalam sebuah SQL Statement untuk mencari sebuah nilai dalam sebuah table yang mempunyai pola string atau karakter tertentu. operator Like ini ditempatkan setelah klausa where dalam sebuah SQL Statement. perbedaan antara operat...

• SQL: Summed Up Null Values in Oracle and SQL Server 2000

  Posted on Saturday March 15th, 2008 at 21:34 in sql

  Jika anda sering menggunakan SQL statement pasti anda pernah melakukan operasi perhitungan matematika terhadap field-field dalam table anda. tapi pernahkah anda bingung mendapatkan perhitungan yang tidak sesuai terhadap field yang bernilai NOT NULL ...

• Oracle SQL: Encrypt Strings using TRANSLATE Function

  Posted on Saturday March 15th, 2008 at 21:16 in sql

  Scroll To Indonesia Version If you are using Oracle as your Database Software to manage your datas, did you know that Oracle have a function to do simple string encryption. Although it was simple but the result is prety powerfull to encrypt any i...

• SQL : Using Column Alias to Clarify Field Header

  Posted on Thursday March 6th, 2008 at 12:29 in sql

  Scroll to Indonesian Version If you have tables that the field are less descriptive, you may want to consider this tips that i will explain below. actually this tips is for you who often use sql editor or DBA (Database Administration) Tools to do q...