2023-05-03 11:06:20 +02:00
|
|
|
== Why is this an issue?
|
|
|
|
|
2020-06-30 12:47:33 +02:00
|
|
|
include::description.adoc[]
|
|
|
|
|
2023-05-25 14:18:12 +02:00
|
|
|
=== Noncompliant code example
|
|
|
|
|
|
|
|
[source,text]
|
|
|
|
----
|
|
|
|
SELECT FIRST_NAME, LAST_NAME, REGION
|
|
|
|
FROM PERSONS
|
|
|
|
ORDER BY 2, 1
|
|
|
|
----
|
|
|
|
|
|
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
|
|
|
|
[source,text]
|
|
|
|
----
|
|
|
|
SELECT FIRST_NAME, LAST_NAME, REGION
|
|
|
|
FROM PERSONS
|
|
|
|
ORDER BY LAST_NAME, FIRST_NAME
|
|
|
|
----
|
2020-06-30 12:47:33 +02:00
|
|
|
|