MySQL SELECT DISTINCT & CONCAT Query with Example

I am using MySQL 8 and was trying to query SELECT DISTINCT with CONCAT on my Linux Mint system. If you have MySQL 5.x, please refer to the official documentations.

Here is the query that worked for me..

SELECT DISTINCT CONCAT( author_fname, ' ',  author_lname) as Author FROM books;