Wm posting one interview question

[badamsrinivas]

Below is one of the interview question..Please find below details

Inline * load[

id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000

];

Inline * load[

id,region,sales
4,south,8999
5,east,8999
5,west,7788
1,east,9000
1,east,8999
] where not exist(id);

what is the output of id?

[badamsrinivas]

Please its important for me, plz answer below query..

load * inline[

id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000

];

load * inline[

id,region,sales
4,south,8999
5,east,8999
5,west,7788
1,east,9000
1,east,8999
] where not exist(id);

what is the output of id?

[durgesh22]

Output table will have below records

id,region,sales

1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000

4,south,8999
5,east,8999