I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

Paresh i think it because it would reorder the data of table if we are putting clustered index on table ... may be one of this reason but not 100% sure....

Paresh i think it because it would reorder the data of table if we are putting clustered index on table ... may be one of this reason but not 100% sure....

Paresh i think it because it would reorder the data of table if we are putting clustered index on table ... may be one of this reason but not 100% sure....

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the SEL