‘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 |
What is the difference between varchar and nvarchar types?
What are the purposes of floor and sign functions?
Which language is supported by sql server?
Difference between uniqe index and uniqe constraint?
What is the difference between dropping a database and taking a database offline?
What are rows and columns?
What is the new security features added in sql server 2016? : sql server security
What is an index in a database?
What does it mean to normalize data?
How to connect php with different port numbers?
What is the cartesian product of table?
How do you optimize Sql queries ?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)