What will happen if we execute below query? Will below VIEW be created or not?

create view vw_emp_information
as
Select TOP 50 * from employee_master order by employee_name;

Answer:

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.