Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there any function similar to Having Clause of Sql Statement.
Hello
Can you help me to adapt this SQL for QlikView?
SELECT FULLNAME_RAW_SOURCE || ' ' || BIRTHDATE AS FIO_DR, COUNT (*)
FROM tab1
GROUP BY FULLNAME_RAW_SOURCE || ' ' || BIRTHDATE
HAVING COUNT (FULLNAME_RAW_SOURCE || ' ' || BIRTHDATE) > 1
I need a unique record "name + date of birth" in the case, if it more than one in the source table (tab1).
Hello, try this article