Pages

▼
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, November 13, 2015

Using Ampersand Sign in Update Statement

›
update <table_name> set field_name = 'ABC' || chr(38) || 'DEF' where <where clause> 38 is the ASCII code f...
1 comment:
Friday, May 6, 2011

Table Joins - XVI

›
Table Joins All of the queries up until this point have been useful with the exception of one major limitation - that is, you've been s...

Mathematical Functions - XVI

›
Mathematical Functions Standard ANSI SQL-92 supports the following first four basic arithmetic operators: + addition - subtraction * mu...

IN & Between - XV

›
SELECT col1, SUM(col2) FROM "list-of-tables" WHERE col3 IN (list-of-values); SELECT col1, SUM(col2) FROM "list-...

Conditions & Operators - XIV

›
Combining Conditions & Boolean Operators The AND operator can be used to join two or more conditions in the WHERE clause. Both sides of...

ORDER BY clause - XIII

›
ORDER BY is an optional clause which will allow you to display the results of your query in a sorted order (either ascending order or desce...

HAVING clause - XII

›
The HAVING clause allows you to specify conditions on the rows for each group - in other words, which rows should be selected will be based...

GROUP BY clause - XI

›
The GROUP BY clause will gather all of the rows together that contain data in the specified column(s) and will allow aggregate functions to...

Aggregate Functions - X

›
  MIN returns the smallest value in a given column MAX returns the largest value in a given column SUM returns the sum of the numeric va...

SELECT Statement - IX

›
The SELECT statement is used to query the database and retrieve selected data that match the criteria that you specify. The SELECT stateme...

Drop Table - VIII

›
The  drop table  command is used to delete a table and all rows in the table. To delete an entire table including all of its rows, issue th...

Deleting Records - VII

›
The  delete  statement is used to delete records or rows from the table. delete from "tablename" where "columnname" ...

Updating Records - VI

›
The  update  statement is used to update or change records that match a specified criteria. This is accomplished by carefully constructing ...

Inserting into a Table - V

›
The  insert  statement is used to insert or add a row of data into the table. To insert records into a table, enter the key words  insert i...

Creating Tables - IV

›
The  create table  statement is used to create a new table. Here is the format of a simple  create table  statement: create table "tab...

Selecting Data - III

›
The  select  statement is used to query the database and retrieve selected data that match the criteria that you specify. Here is the forma...

Table basics - II

›
A relational database system contains one or more objects called tables. The data or information for the database are stored in these table...

What is SQL? - I

›
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI ...