Order by Current Month

Question

Dear Sir , how to show data in sql server 2005 order by current month Like Aug sep oct......

Ronika Jency · Answer

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) ELSE month(DOB) END Result Sample Query Format: select datename(month,ColumnName) From TableName Order By Case When month(ColumnName) ELSE month(ColumnName) END

Yogesh Ghorpade · Answer

Select Field 1 ,Field 2 ,Field 3 ,Field 4 From TableName Where If Any Cindition Order By month(getdate())

Rafnas T P · Answer

hi, try as follows SELECT DateField FROM Table ORDER BY month(DateField)

Pravat Kumar · Answer

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

Rajeesh Menoth · Answer

Hi, As a beginner you can read the following article : https://www.w3schools.com/sql/sql_orderby.asp

Jenith Thakkar · Answer

Will you please provide your table structure

Manikandaprabu V · Answer

SELECT DateField FROM Table ORDER BY DateField -- this give month wise and day wise

Order by Current Month

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)