W_B_20170728_76 - Order of data displayed is not as per ORDER BY clause

mvsagar / queper_rep

wjISQL - a webapp for accessing relational databases

0 stars 1 forks source link

W_B_20170728_76 - Order of data displayed is not as per ORDER BY clause #28

Closed mvsagar closed 7 years ago

mvsagar commented 7 years ago

Order of data displayed is not as per ORDER BY clause of SQL statement. This seems to be due to SNO column, not part of SQL statement, is treated as char column This could be fixed if the SNO column is treated as number.

mvsagar commented 7 years ago

You need at least 10 rows in the result set to see the problem. Row 10 comes after row 1 instead of row 9!