PL/SQL Retrieving Max Value + Corresponding Another Column Value

   select *
         from( select b.id,
                            b.account_no,
                            max(b.id) over() mx
                 from table_bank b
                where b.user_id=p_user_id
                  and b.default=1
              ) hes
        where hes.id = hes.mx ;
     

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document