SQL Distinct Syntax

Question

Starting to learn SQL, right now I'm using mysql to start off. Currently stuck on one problem on my SQL homework in which I have to:

Show all genres in which there is at least one title. List each genre only once.

Tried using command line:

SELECT DISTINCT Genre, Title, FROM Titles;

Does not give me my desired result.

enter image description here

Can anyone please show me, what I'm doing wrong here?

distinct is same for mysql and oracle: Read this techonthenet.com/oracle/distinct.php — Premraj
– Premraj, Commented Apr 13, 2015 at 7:01

Iłya Bursov · Accepted Answer · 2015-04-13 06:11:29Z

2

your task is to show genres, why do you need title in query?

SELECT DISTINCT Genre FROM Titles;

answered Apr 13, 2015 at 6:11

Iłya Bursov

24.4k4 gold badges36 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Iłya Bursov Over a year ago

@RahulTripathi yes, if this genre in titles table - it has at least one title already

Rahul Tripathi · Accepted Answer · 2015-04-13 06:13:59Z

0

You can try like this:

SELECT * FROM Titles where Titles is not null
group by Genre

answered Apr 13, 2015 at 6:13

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Comments

Rene Korss · Accepted Answer · 2015-04-13 06:38:28Z

0

Use GROUP BY

SELECT Genre, Title FROM Titles WHERE Title <> '' GROUP BY Genre;

See example SQL Fiddle.

edited Apr 13, 2015 at 6:38

answered Apr 13, 2015 at 6:13

Rene Korss

5,4943 gold badges33 silver badges39 bronze badges

Comments

Premraj · Accepted Answer · 2015-04-13 06:59:39Z

0

you use comma after Tilte that is wrong syntax.

This wright way is

SELECT Genre, Title FROM Titles WHERE Title IS NOT NULL GROPU BY Genre;

edited Apr 13, 2015 at 6:59

Premraj

75.4k27 gold badges246 silver badges186 bronze badges

answered Apr 13, 2015 at 6:14

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Collectives™ on Stack Overflow

SQL Distinct Syntax

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related