Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
'I have a database in which one of the column has dates and some duplicate values or records in it. i need to show only count(date).
plz check the attachmnt
Hi....
Please find the attachment.
I have used Flag it is coming right now.
count(if(isnum(date#(date, 'DD-MMM-YYYY')), distinct date))
yes , but how can we create a flag?