Home / Vulnerability Database / T-SQL : Use of TOP without ORDER BY
T-SQL

T-SQL : Use of TOP without ORDER BY

Overview

The application uses SELECT statement with TOP, but without ORDER BY clause. When TOP is used in conjunction with the ORDER BY clause, the result set is limited to the first N number of ordered rows; otherwise, it returns the first N number of rows in an random order, which may lead to undefined behavior.

References

LOW

DerScanner Severity Score

Do you want to fix T-SQL : Use of TOP without ORDER BY in your application?

See also

T-SQL

T-SQL : Weak encryption algorithm

T-SQL

T-SQL : Weak hashing algorithm

T-SQL

T-SQL : Weak random number generator