Can we use order by clause when defining a view?

Aggree...but putting the TOP clause ... will restrict the number of rows while fetching. Better write view without any order inside view and use the order by clause while fetching from view.
Example
create view vw_test
as
select * from auth_agcy -- Here no TOP or ORDER BY clause is used just to make sure thatthe view returns all rows.
Go
select * from vw_test order by agcy_id asc -- Use ORDER BY here as per our requirement liek a table query.

Aggree...but putting the TOP clause ... will restrict the number of rows while fetching. Better write view without any order inside view and use the order by clause while fetching from view.
Example
create view vw_test
as
select * from auth_agcy -- Here no TOP or ORDER BY clause is used just to make sure thatthe view returns all rows.
Go
select * from vw_test order by agcy_id asc -- Use ORDER BY here as per our requirement like a table query.

hmmm sounds logical

The question was only whether we can use order by clause in a view or not.
if so, how. No point in discusssing it that long. Kindly post these arguments in the
Forums section
Thanks.

ya totally agree with Ddd