What will happen when we fire below query?

select employee_id,first_name,middle_name,dob from employee_master order by 2,2;

Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 1244 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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 | Alert Moderator