‘Order by’ is not allowed in a view how can you sort information from a view?



‘Order by’ is not allowed in a view how can you sort information from a view?..

Answer / Sumit Raj Sharma

You can sort information from a view by creating a derived table or temporary table from the view and then applying the ORDER BY clause to that table. For example: SELECT * FROM (SELECT * FROM YourView) AS sorted_view ORDER BY column_name

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between varchar and nvarchar types?

1 Answers  


What are the purposes of floor and sign functions?

1 Answers  


Which language is supported by sql server?

1 Answers  


Difference between uniqe index and uniqe constraint?

1 Answers  


What is the difference between dropping a database and taking a database offline?

1 Answers  


What are rows and columns?

1 Answers  


What is the new security features added in sql server 2016? : sql server security

1 Answers  


What is an index in a database?

1 Answers  


What does it mean to normalize data?

1 Answers  


How to connect php with different port numbers?

0 Answers  


What is the cartesian product of table?

1 Answers  


How do you optimize Sql queries ?

0 Answers   Cognizant,


Categories