Welcome to TDBSoverflow, Our class's own StackOverflow. Our rules:
  1. Use only meaningful and self-explanatory titles
  2. Tag your questions with meaningful keywords
  3. Use upvotes and downvotes to rate the answers
  4. When you receive a satisfying answer - Click the "V" button
Remember: you may get up to 5 bonus points to your final grade!

מבחן 2013 שאלה 1 -ד

+2 votes
13 views

general question

if we have this query:

SELECT DISTINCT show_at 

FROM V1

 GROUP BY show_at 

HAVING COUNT(*) >1;

Do we really need the DISTINCT ?

I think GROUP BY is doing the same , no ?

asked Feb 3, 2018 by tikitak (2,970 points)

1 Answer

+1 vote
 
Best answer
Yes. Distinct is redundant here.
answered Feb 3, 2018 by Assaf (31,090 points)
selected Feb 3, 2018 by tikitak
...