Use Of Between Operator In Teradata

[Shrutisinha]

need a help in using between operator in tera data
i want to ose as condition and other conditio too
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

[vijaydiwakar]

need a help in using between operator in tera data
i want to ose as condition and other conditio too
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

just give me the qry
i'll try to solve it

[Shrutisinha]

just give me the qry
i'll try to solve it

select * from emp H
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)

ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

[Shrutisinha]

need a help in using between operator in tera data
i want to ose as condition and other conditio too
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

select * from emp H
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)

ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

[vijaydiwakar]

select * from emp H
where H.BILLED_DT BETWEEN Max(H.BILLED_DT) AND add_months(Max(H.BILLED_DT),-1)

ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE

if i'm not wrong u like to get records between the month which is max?
i.e. data of one month perticular?