Home Forums SQL Server 2008 SQL Server Newbies Want to categorize the salaries of employee. RE: Want to categorize the salaries of employee.

  • April 5, 2013 at 2:40 pm

    #1604140

    i think you can streamline it a bit by using a neat technique using SUM(CASE..)

    SELECT

    SUM(CASE WHEN SALARY BETWEEN 10000 AND 20000 THEN 1 ELSE 0 END) As Range1,

    SUM(CASE WHEN SALARY BETWEEN 20001 AND 80000 THEN 1 ELSE 0 END) As Range2,

    SUM(CASE WHEN SALARY > 80000 THEN 1 ELSE 0 END) As Range3

    From PEOPLE

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!