Re: In SQL Query: I have three tables A, B, and C,... - Page 2 - Qlik Community

Report Inappropriate Content · ‎2016-09-17

Dear all,

Can anyone help me out below the SQL query, please?

I have three tables A, B, and C, each table having employee and their salary, I want to get the high salary from each table in one table.

What is the SQL query for this, below the one example tables.

Ex: Table A

Table B

Table C

Output would be like these

Table D

Report Inappropriate Content · ‎2016-09-18

Hi Sunny,

the 1st highest salary will be 120000 Alex, but here shows

Maxwell 8000

Alex 120000

Kevin 83000

sunny_talwar · ‎2016-09-19

That is just the matter of sorting it my friend....

Report Inappropriate Content · ‎2016-09-19

Alright.

In SQL Query: I have three tables A, B, and C, each table having employee and their salary, I want to get the high salary from each table in one table.