topic Re: 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. in QlikView

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.

Wed, 25 Nov 2020 16:16:04 GMT

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

Employee	Salary
David	66000
Michel	60000
Richard	56000
Daniel	72000
Maxwell	80000
Ronald	75000

Table B

Employee	Salary
Raj	90000
Krish	55000
Mohan	71000
Mary	69000
Alex	120000
Soham	92000

Table C

Employee	Salary
Trump	45000
Modi	59000
Greek	76000
Joshi	61000
Kevin	83000
Charlet	74000

Output would be like these

Table D

Employee	Salary
Alex	120000
Kevin	83000
Maxwell	80000

Re: 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.

sunny_talwar — Sat, 17 Sep 2016 23:40:54 GMT

You are looking for an SQL query or do you want to do this in QlikView?

Re: 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.

Sun, 18 Sep 2016 00:26:16 GMT

‌Hello Sunny Glad to you.

This query belongs to SQL database but if you are okay - I wish to see both queries in SQL and Qlikview.

Mean while I can compare what's the differences between both queries.

Thanks,

Bob.

Re: 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.

ziadm — Sun, 18 Sep 2016 03:39:02 GMT

SELECT Employee, Max(Salary) as Salary FROM tableA

Group by Employee

UNION

SELECT Employee, Max(Salary) as Salary FROM tableB

Group by Employee

UNION

SELECT Employee, Max(Salary) as Salary FROM tableC

Group by Employee;

Re: 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.

Sun, 18 Sep 2016 03:55:50 GMT

‌HI Ziad,

I appreciated your response,

Still I have confuse Group by is used for aggregated, if apply Group by to employee column, its aggregates to employee.

Could you please explain me once.

Thanks,

Bob

Re: 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.

Anil_Babu_Samineni — Sun, 18 Sep 2016 03:57:45 GMT

Sunny, How to do in Qlikview? For ref, PFA.

Re: 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.

ziadm — Sun, 18 Sep 2016 04:04:33 GMT

Hi Anil

Employees:

Load Employee, Max(Salary) as Salary FROM tableA

Group by Employee

Concatenate

SELECT Employee, Max(Salary) as Salary FROM tableB

Group by Employee

Concatenate

SELECT Employee, Max(Salary) as Salary FROM tableC

Group by Employee;

Re: 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.

Anil_Babu_Samineni — Sun, 18 Sep 2016 04:07:39 GMT

I don't think so this is workable. But thanks. Have a look of my attachment

Re: 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.

Sun, 18 Sep 2016 04:22:59 GMT

Hi Anil,

I'm unable to open that attachment, getting Qlikview error

PFA error message

Re: 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.

sunny_talwar — Sun, 18 Sep 2016 10:19:35 GMT

Anil -

One option is to do it like this:

TableA:

LOAD *,

'TableA' as Flag;

LOAD * Inline [

Employee, Salary

David, 66000

Michel, 60000

Richard, 56000

Daniel, 72000

Maxwell, 80000

Ronald, 75000

];

TableB:

LOAD *,

'TableB' as Flag;

LOAD * Inline [

Employee, Salary

Raj, 90000

Krish, 55000

Mohan, 71000

Mary, 69000

Alex, 120000

Soham, 92000

];

TableC:

LOAD *,

'TableC' as Flag;

LOAD * Inline [

Employee, Salary

Trump, 45000

Modi, 59000

Greek, 76000

Joshi, 61000

Kevin, 83000

Charlet, 74000

];

FinalTable:

NoConcatenate

LOAD Flag,

Max(Salary) as MaxSalary,

FirstSortedValue(Employee, -Salary) as EmployeeWidMaxSalary

Resident TableA

Group By Flag;

Re: 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.

Sun, 18 Sep 2016 20:44:18 GMT

Hi Sunny,

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

Maxwell 8000

Alex 120000

Kevin 83000

Re: 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.

sunny_talwar — Mon, 19 Sep 2016 23:36:48 GMT

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

Re: 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.

Mon, 19 Sep 2016 23:43:27 GMT

Alright.