DTM SQL editor Online Documentation - DTM SQL editor, SQL builder. Build WHERE clause

Product Home

DTM SQL editor Online Documentation

General

Product features

Macros: definition and using

Database schema viewer

Find database object

Data editor

Schema object

Filter database schema

SQL builder

Select type of the statement

Specity objects for select

Build WHERE cause

Select tables or views

Select one table or view

Select fields

Set or change values

ORDER BY and GROUP BY

Plug-ins and SDK

Plug-in sample, sources

Plug-ins Library

General information

Directory by DBMS

MS SQL Server

Run Query Analyzer

Oracle

Run SQL*Plus

General

Insert Module Header

External preprocessor

Run external tool

Run after script execution

Save/Load Hisroty

Send script by e-mail

Simply preprocessor

WinDiff interface

Directory by functions

Editor plug-ins

Insert Module Header

Run external tool

Run Oracle SQL*Plus

Run MS Query Analyzer

Send script by e-mail

Schema plug-ins

Results plug-ins

Common plug-ins

Run WinDiff

Save/Load Hisroty

Preporcessors

External preprocessor

Simply preprocessor

After execution plug-ins

Run after script execution

Information

Troubleshooting guide

Glossary

SQL reference

SQL quick reference

SQL builder. Build WHERE clause

You can specify an arbitrary number of comparisons in a WHERE clause.

They will be linked to each other by either OR or AND operators.

A HAVING statement is constructed much as a WHERE one.