Answer: Yes,we can if
Top keyword is specified in a Select Statement.Then we can use order by clause.As in case of View we can achieve the same thing if Top keyword is specified.
For Example:-
With CTE_Project_Info
As
(
Select Top 10 * From Project_Master Order By Project_Name;
)
Asked In: Many Interviews |
Alert Moderator