yusufm 48726 (6/5/2015)
Yes I have grouped it on date entered and company name and I tried what you suggested and still the same result.
Here is your original post:
yusufm 48726 (6/3/2015)
Hi,I have compiled a report where in SQL query I have used Order By DateEntered, Value DESC but somehow when I check all the lines it does not sort it properly or for example
1022
987
876
870
950
690
580
I have gone through everything but I cannot understand as why is it acting like this?
I have sorted the column sort by value ztoa but still same result.
You are only showing one column when you are sorting/grouping by multiple columns. We need more information to really help.
If you could post the DDL (CREATE TABLE statement) for the table(s) involved, some sample data that represents the problem domain (as INSERT INTO statements) for the table(s) involved, and the expected results based on the sample data we can provide you with much better answers and tested code.