SQLServerCentral / SQL Server 7,2000 / Strategies / Select clause SQL Quary / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:29:57 GMT20RE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxAha!!!!! I got Now i am able to create such queries :-) thanks for help.....Fri, 03 Jul 2009 03:46:43 GMTsaurabhvashisthaRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxTake a look at Books Online [url]http://msdn.microsoft.com/en-us/library/ms130214.aspx[/url]Fri, 03 Jul 2009 03:34:17 GMTDave BallantyneRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspx... or if it's homework, you need to do a bit more studying.:-DFri, 03 Jul 2009 03:30:05 GMTIan ScarlettRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxYes 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...Fri, 03 Jul 2009 03:20:58 GMTsaurabhvashisthaRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxI dont wish to be rude , but if that is causing you troubles you really need to go on a course.Fri, 03 Jul 2009 03:13:16 GMTDave BallantyneRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxCan you Please provide a query for getting that result...Fri, 03 Jul 2009 03:07:06 GMTsaurabhvashisthaRE: Select clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxBy using the case statementselect ....,case when money >=10000 then 'A' else 'B' end as Grade from ....Fri, 03 Jul 2009 03:03:16 GMTDave BallantyneSelect clause SQL Quaryhttp://www.sqlservercentral.com/Forums/Topic746875-49-1.aspxLets Create a tableCreate 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 likeResult should beName GradeA Ab Ad Af Ag bh Ak bl An b How do I accomplish this can anyone suggestFri, 03 Jul 2009 03:00:41 GMTsaurabhvashistha