Where « Select Query « Oracle PL / SQL

1.

Query a varchar2 type column in where statement

2.

The TO_DATE function in where clause

3.

WHERE clause with a GROUP BY clause

4.

A list of all Employees whose salary is more than $5000

5.

Use an analytical function in a WHERE clause

6.

Using the WHERE, GROUP BY, and HAVING Clauses Together

7.

Use ROWNUM in where clause

8.

Where clause converts text with date value format to date value

9.

Use Trunc in where clause

10.

Combining WHERE Conditions

11.

List all employees who are younger than Jane

12.

List all employees with salary between 1300 and 1600