Order by Current Month

yesubabu k

8y930

Dear Sir ,

how to show data in sql server 2005

order by current month

Aug

sep

oct......

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ronika Jency8y ago
Hi,

Table Name: userdetails

Table Structure

Table data:

Query, you asked

select
left(convert(varchar,datename(month,DOB),100),3)
From
userdetails
Order By Case When month(DOB) < month(GetDate()) Then month(DOB) +12
ELSE month(DOB) END

Result

Sample Query Format:

select
datename(month,ColumnName)
From
TableName
Order By Case When month(ColumnName) < month(GetDate()) Then month(ColumnName) +12
ELSE month(ColumnName) END
+1
Yogesh Ghorpade8y ago
Select

Field 1
,Field 2
,Field 3
,Field 4
From TableName

Where If Any Cindition

Order By month(getdate())
+1
Rafnas T P8y ago
hi,

try as follows

SELECT DateField
FROM Table
ORDER BY month(DateField)
+1
Pravat Kumar8y ago
Hello Yesubabu,

Please use the below query, that might solve your problem.

CREATE FUNCTION fn_MonthNameToMonthNumber (@monthName VARCHAR(20))

RETURNS INT

AS

BEGIN

DECLARE @monthNumber AS INT;

SELECT @monthNumber = CASE @monthName

WHEN 'January'

THEN 1

WHEN 'February'

THEN 2

WHEN 'March'

THEN 3

WHEN 'April'

THEN 4

WHEN 'May'

THEN 5

WHEN 'June'

THEN 6

WHEN 'July'

THEN 7

WHEN 'August'

THEN 8

WHEN 'September'

THEN 9

WHEN 'October'

THEN 10

WHEN 'November'

THEN 11

WHEN 'December'

THEN 12

END

RETURN @monthNumber

END

select Name,Age,Salary,dbo.fn_MonthNameToMonthNumber(MONTH) as MonthNO Into #tempTable from Yourtable where (yourCondition)

select Name,Age,Salary from #tempTable order by MonthNO ASC|DESC
+1
Rajeesh Menoth8y ago
Hi,

As a beginner you can read the following article :

https://www.w3schools.com/sql/sql_orderby.asp
+1
Jenith Thakkar8y ago
Will you please provide your table structure
+1
Manikandaprabu V8y ago
SELECT           DateField
FROM      Table
ORDER BY      DateField -- this give month wise and day wise
+1