SQL Statement to fetch sum(salary) for employees

0 votes
Can someone help me to form SQL Statement to fetch sum(salary) for employees department wise in tableau?. I don't know SQL?
May 22 in Tableau by preeti
24 views

1 answer to this question.

0 votes
Hi Preeti,

Try this,

SELECT DEPARTMENT, SUM(SALARY) FROM EMPLOYEES GROUP BY DEPARTMENT.

Hope it works!
answered May 22 by anonymous
• 28,040 points

Related Questions In Tableau

0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
58 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
160 views
0 votes
1 answer
0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
24 views
0 votes
1 answer
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,041 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
89 views
0 votes
1 answer

How to Sum based using an if statement?

Hi Priya, Follow below steps: 1.  Click on Analysis ...READ MORE

answered Apr 25 in Tableau by Cherukuri
• 28,040 points
20 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 28,040 points
28 views