DB2 - SQL TUTORIAL - DB2 SQL TUTORIALS   DB2 SQL - DML (Data Manipulation Language) - Part II Different Types of SELECTSSELECT * SELECT COLUMN(s) SELECT DISTINCT SELECT . WHERE SELECT .. AND / ORSELECT .. LIKESELECT .. INBETWEEN Operator. Let us assume we have following tables defined on our database. Select all records from DEPARTMENT table. SQL Query : SELECT * FROM DEPARTMENTResult : Get all Department names from the table.

SQL Query : SELECT DEPTNAME FROM DEPARTMENTGet distinct departments from EMPLOYEE table. SQL Query : SELECT DISTINCT DEPT FROM EMPLOYEEResult : DEPTA0. D0. 1Get the all the employees working in department number A0.

SQL Query : SELECT * FROM EMPLOYEE WHERE DEPT = 'A0. Result : Following row wont get displayed since this employee belong to DEPT D0. MIKE DWAYER 1. D0. 1 1. 50. 00 2. Following Relational Operators we can use in WHERE clause.

The SQL UPDATE Statement. The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax.

The WHERE clause is used to specify that only certain rows of the table are displayed, based on the criteria described in that WHERE clause. Minnesota Marriage License Name Change. Complex Comditions The AND operator joins two or more conditions, and displays a row only if that row's data satisfies ALL conditions listed.

For example, to display all staff making over $1. A0. 0 use: SQL Query : SELECT EMPNAMEFROM EMPLOYEEWHERE SALARY > 1. AND DEPT = 'A0. 0'Result . The OR operator joins two or more conditions, but returns a row if ANY of the conditions listed hold true. LIKE - NOT LIKE Get all employee details whoes names starts with M. SQL Query : SELECT * FROM DEPT FROM EMPLOYEE WHERE EMPNAME LIKE 'M%'Result : The percent sign (%) is used to represent any possible character (number, letter, or punctuation).

Examples of Joins. DB2/SQL Version 7 and later. A join combines fields in two or more tables by matching values. If a specified value in one table matches the. SQL WHERE IN Examples Problem: List all suppliers from the USA, UK, OR Japan SELECT Id, CompanyName, City, Country FROM Supplier WHERE Country IN ('USA', 'UK', 'Japan').

To find those people with Name's ending in . The '%' can be used for any.

NOT LIKE displays rows not fitting. NOTE : The wild- card characters for LIKE are '%' and '.

Underscore matches any single character. Percent matches zero or more characters. When want to compare list of values compare against the table field you can use IN. Get all employee details for employee numbers 1. SQL Query : SELECT EMPNAME FROM EMPLOYEE WHERE EMPNO IN ( 1.

Result : SELECT .. BETWEEN You can use BETWEEN Operator , to get the range of records between two values.

DB2 SQL - DML (Data Manipulation Language) - Part II Different Types of SELECTS SELECT * SELECT COLUMN(s) SELECT DISTINCT SELECT. WHERE SELECT. The SELECT statement is used to query the database and retrieve selected data that match the criteria that you specify. A step-by-step tutorial with live interpreters, allowing access to tables using any of Oracle, SQL Server, MySQL, Access or PostgreSQL engines. Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, and XML.