topic Re: min salary employee details in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/min-salary-employee-details/m-p/153388#M40336 <HTML><HEAD></HEAD><BODY><P>Question 2: These two syntaxes are equivalent. SQL queries describe what you want. SQL processors (part of the DBMS) try to find the optimal way of answering your query. Only testing, within your own configuration, will tell you which is best.</P><P></P><P>PG</P></BODY></HTML> Sun, 21 Sep 2014 19:01:01 GMT PGStats 2014-09-21T19:01:01Z min salary employee details https://communities.sas.com/t5/SAS-Procedures/min-salary-employee-details/m-p/153387#M40335 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>1.howmany other ways to do the below query?</P><P>select height,name from sashelp.class having height=min(height);</P><P></P><P>2. is below queries performs same?(where/on)</P><P>select&nbsp; * from a,b where a.empid=b.empid </P><P>select * from a inner join b on a.empid=b.empid</P><P></P><P>note: I want to know which is performance wise best. I already put fullstimer,I am getting cputime and os memory but cpu time is showing same </P></BODY></HTML> Sun, 21 Sep 2014 17:57:00 GMT https://communities.sas.com/t5/SAS-Procedures/min-salary-employee-details/m-p/153387#M40335 rajeshm 2014-09-21T17:57:00Z Re: min salary employee details https://communities.sas.com/t5/SAS-Procedures/min-salary-employee-details/m-p/153388#M40336 <HTML><HEAD></HEAD><BODY><P>Question 2: These two syntaxes are equivalent. SQL queries describe what you want. SQL processors (part of the DBMS) try to find the optimal way of answering your query. Only testing, within your own configuration, will tell you which is best.</P><P></P><P>PG</P></BODY></HTML> Sun, 21 Sep 2014 19:01:01 GMT https://communities.sas.com/t5/SAS-Procedures/min-salary-employee-details/m-p/153388#M40336 PGStats 2014-09-21T19:01:01Z