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;

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 302 | Points: 40
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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response