Error 'ORDER BY items must appear in the select list if SELECT DISTINCT is specified' in SQL Server

nedash

this is storeprocedure in database:

CREATE  procedure [dbo].[Select_FilmGenre]
as
begin
SET NOCOUNT ON
select DISTINCT Genre
from SerialFilm
order by GenrePre asc

but when I run it this error happen:

Msg 145, Level 15, State 1, Procedure Select_FilmGenre, Line 5 ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

what should I do?

Best Regards

Neda

dharmend...

0 1

As the error suggest ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Select query should be like below.

select DISTINCT Genre,GenrePre from SerialFilm order by GenrePre asc

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html