var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Distinct Query
When i run this query,
select distinct(firstname + ' ' + lastname), firstname, lastname, department
it brings out 149 records
but when i run it with the extension field
select distinct(firstname + ' ' + lastname), firstname, lastname, department, extension
Is there like a limit to the distinct query on the number of columns returned ?
Originally Posted by jcwc888
r u getting a different no of records when the 2nd query is executed?
if so, the fields SELECTed by the second query will not be DISTINCT (with extension added to the SELECT list)