You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Select firstName, lastName, age, city
from test.dbo.person
Order by age desc
After running the query you then apply filter in results window in dbeaver on city column, you get the following error:
SQL Error [1033] [S0001]: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
DBeaver Version
24.0.4.202405051837
Operating System
Windows 11
Database and driver
SQL Server 2014
MSSql jdbc 12.4.2
Steps to reproduce
Write a new query in New SQL Script window
Select firstName, lastName, age, city
from test.dbo.person
Order by age desc
Run the query
In the results window try to filter on the city column to any value
Additional context
No response
The text was updated successfully, but these errors were encountered:
Description
When you write a sql such as:
Select firstName, lastName, age, city
from test.dbo.person
Order by age desc
After running the query you then apply filter in results window in dbeaver on city column, you get the following error:
SQL Error [1033] [S0001]: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
DBeaver Version
24.0.4.202405051837
Operating System
Windows 11
Database and driver
SQL Server 2014
MSSql jdbc 12.4.2
Steps to reproduce
from test.dbo.person
Order by age desc
Additional context
No response
The text was updated successfully, but these errors were encountered: