|
|
Posted by max.capo on 09/14/05 17:13
Hello guys,
maybe you can point me into the right direction on this SQL Query that
is driving me crazy:
I've got the following table:
Contact Company Job_Title Importance
1 Company A CEO 10
2 Company A DIR 9
3 Company B MAN 5
4 Company B DIR 9
5 Company C PRG 4
I need to extract a single value, for each company, with the highest
contact (through the "importance" field).
In the example, I would need to have the following results:
Contact Company Job_Title Importance
1 Company A CEO 10
4 Company B DIR 9
5 Company C PRG 4
....any idea about how can i do it ?
Thanks very much fo your help
Massi
Navigation:
[Reply to this message]
|