A Question on SQL

[Tofunmi-I]

I'm using a JOIN statement to merge EmployeeID, First Name, and Last Name from Table 1 with Job Title and Salary from Table 2.
Using a CASE statement, I'm adjusting salaries after a raise, with a specific percentage for 'salesman' job title.

How can I make 'salesman' job title employees appear first in the result column, followed by other job titles? I want to emphasize their contribution with a 50% raise. Open to suggestions and best practices. Thanks!

[namith1003]

 SELECT 
     EmployeeID,
     FirstName,
     LastName,
     JobTitle,
     CASE 
         WHEN JobTitle = 'salesman' THEN Salary * 1.5 
         ELSE Salary
     END AS AdjustedSalary
 FROM 
     Table1
 JOIN 
     Table2 ON Table1.EmployeeID = Table2.EmployeeID
 ORDER BY 
     CASE 
         WHEN JobTitle = 'salesman' THEN 0
         ELSE 1
     END;

when you order in ascending order, and assign 0 only when it is salesman then all the salesman rows will be at the beginning followed by anything else as you asked, you may try this and if this is the answer then all good if not please add on to the request.

I think you had asked this before as well.

[Tofunmi-I]

It did work. Thanks

[ghostinhershell]

Hi @Tofunmi-I,

The GitHub Community on Discussions is a space for all GitHub users to come and discuss ideas and projects. Your post was removed because it contained content that violates our Community Code of Conduct, including posting the same comment in multiple places. As a result, we have hidden the duplicate comments, and we ask that you no longer cross-post.

For additional guidance, please review our Community on Discussions Code of Conduct and GitHub’s Terms of Service.

[Tofunmi-I]

I sincerely apologize for that. I am new to GitHub and still trying to navigate my way around it.

[Jeesejack]

perfect

[queenofcorgis]

Thanks for posting in the GitHub Community, @Tofunmi-I !

We’ve moved your post to our Programming Help 🧑‍💻 category, which is more appropriate for this type of discussion.

Please review our guidelines about the Programming Help category for more information.

[WillTheFarmer]

Why is this thread still marked Open and Unanswered?