It will throw an error saying that
Msg 169, Level 15, State 1, Line 1
A column has been specified more than once in the order by list. Columns in the order by list must be unique. It means we have to pass different column_id in order by clause.
Asked In: Many Interviews |