var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
i'm trying to get duplicates out of the my database
SELECT COUNT(*) AS Amount,
GROUP BY FirstName, surname, internalextension
HAVING COUNT(*) > 1 order by firstname, surname
How do i alter the query just retrieve records which have firstname and lastname which are similar but different extension numbers ?
could you pls make it more clear.Perhaps some records with DDL
According to you what does the above query achieve ???
Originally Posted by jcwc888
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data