0

I am trying to execute this sql:

select subject, class, book_name, author, publisher, publish_year from tb_books;

Now, what I want is distinct subject, as well as distinct class, as well as distinct book_name, and go on......

But, as we know if I use distinct with this query as below:

select distinct subject, class, book_name, author, publisher, publish_year from tb_books;

it will result in the complete distinct output of all the select statement.

Is their any way to find out all the distinct values. Please don't suggest to use the distinct query six times with all the columns (one for Class, one for book_name, one for author, etc).

Kindly revert.

Rohit
  • 188
  • 2
  • 18
  • Possible duplicate of [MySQL SELECT DISTINCT multiple columns](http://stackoverflow.com/questions/12188027/mysql-select-distinct-multiple-columns) – radoh Feb 27 '16 at 21:13

1 Answers1

0

You could use GROUP BY to get all the combinations

select subject, class, book_name, author, publisher, publish_year from tb_books
group by subject, class, book_name, author, publisher, publish_year;
Eduardo Salazar
  • 177
  • 7
  • I want disctinct values of a's, b's, c's and d's, not distinct combination of values, my problem got solved by one of the other same question suggested by @radoh – Rohit Feb 28 '16 at 06:04