how to write max function in where condition.

See more:

SQL

while executing below query i am getting error..

select t.d
from
(
select N_Days d , COUNT(N_Days) ds from Tbl_Setting
group by N_Days
)t
where t.ds=MAX(t.ds)

Msg 147, Level 15, State 1, Line 7
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

How we could write this query in other style

Edit:2/ Reposted from Question - 1 [^], Question 2[^]