SQL Query Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

SQL Query Issue

Author

Topic

ravininave
Posting Yak Master

111 Posts

Posted - 2012-12-12 : 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

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-12 : 03:53:58

Select * from BoardMast order by tCount desc ,lDate ~~desc~~;

--
Chandu

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources