Does someone know how to replace null in last row of the column to text in lead function for example
I’m using
lead (ticket_id,1, end of tickets) over (orderby cst id DESC) as ticketnumbers
I want here to get result of last row to show end of tickets instead of null or being empty but every time I get mismatch input.
New contributor
Hanz pecter is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1