Tuesday, August 12, 2014

Retrieving the last record in each group

select *
from comment as m1
left join comment as m2  on ( m1.id<m2.id and m1.vulnerability_id=m2.vulnerability_id)
where m2.id is null
;

Git get all remote branches

git branch -r \ | grep -v '\->' \ | sed "s,\x1B\[[0-9;]*[a-zA-Z],,g" \ | while read remote; do \ git branc...