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 23, 2019 in Tableau by preeti
879 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 23, 2019 by anonymous
• 33,030 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,560 points
602 views
0 votes
1 answer

How to use a IFF statement in Tableau

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

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,590 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,820 points
524 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
9,393 views
+2 votes
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
1,277 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, 2019 in Tableau by Cherukuri
• 33,030 points
728 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, 2019 in Tableau by Cherukuri
• 33,030 points
561 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP