Re: Reverting SQL Standard to SQL-92
> Making it primary key would mean GROUP BY doesn't require name column in Name Table since sno is unique
Doesn't follow. The issue is functional dependency of `name` on `sno---data determines whether an error occurs, so please post a test case that reproduces the problem,
Subject
Written By
Posted
Re: Reverting SQL Standard to SQL-92
October 24, 2018 10:03AM
November 01, 2018 12:18AM
November 14, 2018 08:38AM
November 14, 2018 11:31AM
November 15, 2018 08:50AM
November 26, 2018 02:07AM
November 26, 2018 11:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.