Yes above VIEW will be successfully created because we have used Top keyword and order by clause inside View.
It is said that we can not use order by clause without top keyword inside View.
An we can access Above view as:-
Select * From vw_emp_information.
Asked In: Many Interviews |