----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Latha_G Message 4 in Discussion Thanks Farvin27, it is working... From: "Farvin27" <[EMAIL PROTECTED]> Reply-To: "BDOTNET" <[email protected]> To: "BDOTNET" <[email protected]> Subject: Re: Select Statment query Date: Wed, 15 Mar 2006 22:07:24 -0800 <META content="Microsoft SafeHTML" name=Generator> <STYLE> ThmFgColumnHeader, A.FrameLink, A.HeaderLink, A.FooterLink, A.LgtCmd, A.MSNLink {color:#FFFFFF;} ThmFgTitleLightBk {color:#FF6600;} ThmFgSmallLight {color:#ff0000;} ThmFgNavLink, A.NavLink, A.ChildLink:hover {color:#666699;} ThmFgInactiveText, A.SystemLink {color:#666666;} ThmFgFrameTitle {color:#FFFFCC;} ThmFgMiscText, A.Cat, A.SubCat {color:#336699;} ThmFgCommand, A.Command, A.LargeCommand, A.MsgLink {color:#003366;} ThmFgHeader {color:#333333;} ThmFgDivider {color:#CCCCCC;} ThmBgStandard {background-color:#FFFFFF;} ThmBgUnknown1 {background-color:#FF6600;} ThmBgFraming {background-color:#666699;} ThmBgUnknown2 {background-color:#666666;} ThmBgHighlightDark {background-color:#FFFFCC;} ThmBgHighlightLight, #idToolbar, #tbContents {background-color:#FFFFE8;} ThmBgTitleDarkBk {background-color:#F1F1F1;} ThmBgAlternate {background-color:#ECF1F6;} ThmBgUnknown3 {background-color:#CCCCFF;} ThmBgDivider {background-color:#CCCCCC;} ThmBgHeader {background-color:#9999CC;} ThmBgLinks {background-color:#8696C9;} ThmBgSharkBar {background-color:#8696C9;} ThmBgGlobalNick {background-color:#9394A9;} calfgndcolor {color:#E00505;} calbgndcolor {color:#E00505;} </STYLE> New Message on BDOTNET Select Statment query Reply Reply to Sender Recommend Message 3 in Discussion From: Farvin27 Try these queries If 2 or more employees have same salary - get the Distinct salaries select DISTINCT TOP 3 salary from EMP order by salary DESC If (2 or more employees have same salary) or each one have unique salary - get the top 3 salary (if same salary also) select TOP 3 WITH TIES salary from EMP order by salary DESC Regards, SkyMania View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. 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. Remove my e-mail address from BDOTNET. NRIs Zero balance Account. FREE Money Transfers with FREE DVD ----------------------------------------------------------- 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]
