|
ravininave
Yak Posting Veteran
India
94 Posts |
 Posted - 12/12/2012 : 03:32:32
|
My Table: BoardMast
Structure
AppMstID int
tCount int
lDate Datetime
SrNo int
INSERT INTO BoardMast (1,1,'2012-12-12 13:19:04.873',3)
INSERT INTO BoardMast (2,2,'2012-12-12 13:20:08.407',7)
INSERT INTO BoardMast (3,2,'2012-12-12 13:21:07.647',5)
INSERT INTO BoardMast (4,0,'2012-12-12 13:22:08.257',NULL)
INSERT INTO BoardMast (5,0,'2012-12-12 13:23:23.853',NULL)
INSERT INTO BoardMast (6,0,'2012-12-12 13:25:18.887',NULL)
INSERT INTO BoardMast (7,0,'2012-12-12 13:29:38.743',NULL)
I wish to order on tCount Desc, lDate Desc
for that I wrote:
Select * from BoardMast order by tCount desc ,lDate desc;
it returns
3
2
1
7
6
5
4
first 3 are correct but another 4 are not in order of date
it should
4
5
6
7
Can anyone correct the query.
VB6/ASP.NET
------------------------
http://www.nehasoftec.com |
|
SQL Query Issue
