Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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