tag:blogger.com,1999:blog-7767918376204344706.post1346366379618186316..comments2023-10-25T09:02:03.547-07:00Comments on Sukesh Marla: Get Max Value Without using Max And Order bySukesh Marlahttp://www.blogger.com/profile/16619059549331221666noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7767918376204344706.post-7089168088340472652012-09-25T02:53:58.851-07:002012-09-25T02:53:58.851-07:00In Oracle You Can Use The Following Query To Get T...In Oracle You Can Use The Following Query To Get The Desired Result<br /><br />Select A.Salary<br /> From Salary A<br /> Left Join Salary B<br /> On A.Salary < B.Salary <br /> Where B.Salary Is Null Arifhttps://www.blogger.com/profile/00872546822412483877noreply@blogger.comtag:blogger.com,1999:blog-7767918376204344706.post-85909324490711964682012-09-25T02:53:03.764-07:002012-09-25T02:53:03.764-07:00In Oracle You Can Use The Following Query To Get T...In Oracle You Can Use The Following Query To Get The Desired Result<br /><br />Select A.Salary<br /> From Salary A<br /> Left Join Salary B<br /> On A.Salary < B.Salary <br /> Where B.Salary Is Null Arifhttps://www.blogger.com/profile/00872546822412483877noreply@blogger.comtag:blogger.com,1999:blog-7767918376204344706.post-24845646597930227802011-08-11T03:40:52.992-07:002011-08-11T03:40:52.992-07:00select sal from t1 as e where 0 =(SELECT count(*) ...select sal from t1 as e where 0 =(SELECT count(*) FROM T1 WHERE e.sal<sal)Aamir Khanhttps://www.blogger.com/profile/04936968980822270843noreply@blogger.com