restriction in sqlsyntaxselect distinct


Restriction in SQL

Syntax:

SELECT DISTINCT StudentId

FROM IS_CALLED

WHERE Name = 'Boris'

The WHERE clause operates on the result of the FROM clause in analogous fashion to the way it operates on an arbitrary relation expression. Name = NAME ('Boris') is an open expression. The key word DISTINCT here is redundant, as it happens, because StudentId is a declared key for IS_CALLED.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: restriction in sqlsyntaxselect distinct
Reference No:- TGS0180849

Expected delivery within 24 Hours