Hello,
Empid Empname Depno
1111 yyyyy 10
2222 zzzzz 10
1111 yyyyy 10
Select distinct empname from employee where deptno=10;
With this stmt i can get empnames which are unique.
Outpu as:
1111 yyyy 10
2222 zzzz 10
But The question here is:
If entire row is duplicated then, distinct will work...
anjalive
Last Activity: Aug 14 '15, 09:58 AM
Joined: Jul 29 '15
Location:
-
How to remove duplicates for below scenario
-
Thank you for the reply RonB. Appreciated.
I have one more question.
I just created a script with db tables and output was moved to excel sheets.
Below are two sheets:
Sheet1:
IP address Status
x.x.x.x success
y.y.y.y No Access
z.z.z.z Retired
a.a.a.a Success
Sheet2:
IP address Status
x.x.x.x success
y.y.y.y Success... -
Hello Ron,
I am planning to do automation for macros which is in MS Access DB into Perl Scriot. There in Access DB, we used to compare IP column which is same in both tables and will retrive details whatever required. I got struck at comparing tables. I am not getting idea how to compare. Asking for help this.
Thank youLeave a comment:
-
How to Compare two tables in perl script
Hello,
Can we compare two tables in perl? I mean How can we do it for database tables.
I would like to know the solution for below scenario in perl script.
Here are 2 tables:
Table 1
Names City
aaaaa hyd
bbbbb bang
ccccc chen
dddddd noida
eeeeeee hyd
ffffffffffff chen
Table: 2
Names...
No activity results to display
Leave a comment: