Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare 2 columns on same table with Like operator

Kannan SekarApr 11 2023

I have employee table and I need to fetch the list of employees where first name is not matching with their mail ids. From the below table, in Output we need empid = 1002 since first_name is not matching with mail id

EMPID FIRST_NAME LAST_NAME MAILID

1001 kan seka kan@g.com

1002 Gopi dha luca@g.com

1003 krish dha krish@g.com
This post has been answered by Solomon Yakobson on Apr 11 2023
Jump to Answer
Comments
Post Details
Added on Apr 11 2023
#pl-sql
10 comments
785 views