How do I compare all the column values based on the Partition by with ID
I have a case where there are many rows for the same ID, I just
wanted to know if there is any way to find out whether the given ID
includes some specific value or not.
Table 1ID Dept Salary Flag Date 1 IT 5000 N 2017-01-011 IT 5000 N 2017-01-021 IT 5000 N 2017-01-031 IT 5000 N 2017-01-041 IT 5000 N 2017-01-052 HR 4000 N 2017-01-012 HR 4000 N 2017-01-022 HR 4000 Y 2017-01-032 HR 4000 N 2017-01-042 HR 4000 N 2017-01-053 Fin 4500 N 2017-01-083 Fin 4500 N 2017-01-093 Fin 4500 N 2017-01-103 Fin 4500 N 2017-01-113 Fin 4500 N 2017-01-124 Edu 4800 N�����…
Table 1ID Dept Salary Flag Date 1 IT 5000 N 2017-01-011 IT 5000 N 2017-01-021 IT 5000 N 2017-01-031 IT 5000 N 2017-01-041 IT 5000 N 2017-01-052 HR 4000 N 2017-01-012 HR 4000 N 2017-01-022 HR 4000 Y 2017-01-032 HR 4000 N 2017-01-042 HR 4000 N 2017-01-053 Fin 4500 N 2017-01-083 Fin 4500 N 2017-01-093 Fin 4500 N 2017-01-103 Fin 4500 N 2017-01-113 Fin 4500 N 2017-01-124 Edu 4800 N�����…
Comments
Post a Comment