Select clause SQL Quary

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Strategies » Select clause SQL Quary

Select clause SQL Quary

Rate Topic

Display Mode

Topic Options

Author

Message

saurabhvashistha

Posted Friday, July 03, 2009 3:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 10:54 PM
Points: 4, Visits: 15

Lets Create a table
Create Table test(Name varchar(50), SalaryAmount money)
insert into test(Name, SalaryAmount) values(A, 10000)
insert into test(Name, SalaryAmount) values(b, 11000)
insert into test(Name, SalaryAmount) values(d, 110000)
insert into test(Name, SalaryAmount) values(f, 10000)
insert into test(Name, SalaryAmount) values(g, 9800)
insert into test(Name, SalaryAmount) values(h, 10000)
insert into test(Name, SalaryAmount) values(k, 8000)
insert into test(Name, SalaryAmount) values(l, 10000)
insert into test(Name, SalaryAmount) values(n, 15000)

Now i Have to write a query which give me result like if Salary is greater then or equal to 10000 grade A else b like
Result should be

Name Grade
A A
b A
d A
f A
g b
h A
k b
l A
n b

How do I accomplish this can anyone suggest

Post #746875

Dave Ballantyne

Posted Friday, July 03, 2009 3:03 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

By using the case statement

select ....,case when money >=10000 then 'A' else 'B' end as Grade
from ....

Clear Sky SQL
My Blog
Kent user group

Post #746877

saurabhvashistha

Posted Friday, July 03, 2009 3:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 10:54 PM
Points: 4, Visits: 15

Can you Please provide a query for getting that result...

Post #746878

Dave Ballantyne

Posted Friday, July 03, 2009 3:13 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

I dont wish to be rude , but if that is causing you troubles you really need to go on a course.

Clear Sky SQL
My Blog
Kent user group

Post #746880

saurabhvashistha

Posted Friday, July 03, 2009 3:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 10:54 PM
Points: 4, Visits: 15

Yes Sir i understand that, but i am in urgent need for the query as i am facing issues in developing that, i am new to SQL and i am in learning phase. So Please do help if u can...

Post #746883