sql - Why order of the result varies on using extra brackets in select query -
select distinct (upper(cd)) table end_date > '08-12-2013'
and
select distinct upper(cd) table end_date > '08-12-2013'
the results of both queries same order varies. there explanation ?
as understand there no default 'order' of results unless order clause specified.
this may dependent on rdbms afaik standard sql.
Comments
Post a Comment