Hi,
I’m trying to figure out the best way to get the most common value in a datatable column. If I were to do this in SQL I’d use something like
SELECT top 1 [COLUMNNAME]
FROM TABLENAME
where len([COLUMNNAME])>1
GROUP BY [COLUMNNAME]
I’ve had a look at LYNC and some of the array filters but not managed to find a way. Anyone any ideas?
Thanks in advance