-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Karthikeyan_P
Message 8 in Discussion
Hi Created the following table. create table employee
(
empname varchar(20),
salary money ) Inserted the following records
insert into employee values('Kalyan', 28000)
insert into employee values('Bhavana', 17000)
insert into employee values('Shyam', 32000)
insert into employee values('Ravi', 15000) Query
Select * From employee
Order by (Case When Salary <= 20000 Then -Salary Else null end) DESC,(Case
When Salary > 20000 Then -Salary Else null end) Result empname
salary
-------------------- ---------------------
Ravi 15000.0000
Bhavana 17000.0000
Shyam 32000.0000
Kalyan 28000.0000 (4 row(s) affected) Is this you
wanted ? Kindly send me an reply. Regards, Karthikeyan.P
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
