Sybase InfoMaker 11.5, CD, Win, ENG Spécifications télécharger pdf (Page 184)

100

101

Using Quick Select

162 InfoMaker

SQL expression examples

The first six examples in this section all refer to a grid that contains three

columns from the employee table:

emp_id, dept_id, and salary.

Example 1

The expression <50000 in the Criteria row in the salary column in the grid

retrieves information for employees whose salaries are less than $50,000.

The

SELECT statement that InfoMaker creates is:

SELECT employee.emp_id,

employee.dept_id,

employee.salary

FROM employee

WHERE employee.salary < '50000'

Example 2

The expression 100 in the Criteria row in the DeptId column in the grid

retrieves information for employees who belong to department 100.

The

SELECT statement that InfoMaker creates is:

SELECT employee.emp_id,

employee.dept_id,

employee.salary

FROM employee

WHERE employee.dept_id ='100'

Example 3

The expression >300 in the Criteria row in the EmpId column and the

expression

<50000 in the Criteria row in the Salary column in the grid retrieve

information for any employee whose employee ID is greater than 300 and

whose salary is less than $50,000.

1 2 ... 179 180 181 182 183 184 185 186 187 188 189 ... 827 828

Commentaires sur ces manuels

Pas de commentaire

Sybase InfoMaker 11.5, CD, Win, ENG Spécifications Page 184

Commentaires sur ces manuels