Delphi. 11



         

( DISTINCT)


, .

( ) . DISTINCT. .

SELECT job_code

FROM employee

JOB_CODE

========

VP

Eng

Eng

Mktg

Mngr

SRep

Admin

Finan

Mngr

Mngr

Eng

...

, , . , DISTINCT, , .

SELECT DISTINCT job_code

FROM employee

JOB_CODE

========

Admin

CEO

CFO

Dir

Doc

Eng

Finan

Mktg

Mngr

PRel

SRep

Sales

VP

, DISTINCT .

SELECT first_name, last_name

FROM employee

WHERE first_name = "Roger" ,
- Roger

FIRST_NAME LAST_NAME

=============== ====================

Roger De Souza

Roger Reeves

SELECT DISTINCT first_name, last_name

FROM employee

WHERE first_name = "Roger" ,
- Roger

FIRST_NAME LAST_NAME

=============== ====================

Roger De Souza

Roger Reeves