I have written a query to fetch result in descending order by using order by desc. In test result too I am getting correct result however when I see same query result in browse it's showing me result in asecending order

In the screen, verify if exists any component that is override the order of records, for example "ListSortColumn".



Hi Pratiksha,

Did you check, if the result grid is applying any filter on the result passed to it from database? It could be the case, SQL is resulting correct ordered results, but page/grid/table itself it applying any sorting on the result set.