Hide duplicates from query

[ChristopherL]

Hi there!
I have a query showing duplicates, I want to hide the duplicates that have a null value in one of the rows..

Trunc_Name M_UNDERLYIN MaturityDate Duration SumOfSumOfM_VEGA Volatility
SPX P1400 DEC13 INX 21-dec-13 4,766666667 -108 812,00 0,22437
SP6652 CALL SP6652 04-okt-17 50,86666667 124 376,00 0,21
SP6652 CALL SP6652 04-okt-17 50,86666667 124 376,00

Here's an example of the a duplicate, all 4 first rows are duplicates, but the last value is null for the last duplicate. I want to hide the one the duplicate that has null value!

Thank you!

 

[JHB]

Can't you use the "Is Not Null" for the criteria in the select statement?

 

[ChristopherL]

Can't you use the "Is Not Null" for the criteria in the select statement?

I would but there are some rows that arent duplicates that still have null values..

 

[JHB]

Do you have some sample data to play with, (in an Excel sheet or MS-Database)?

 

[jdraw]

I agree with JHB sample data may help us understand. My basic question though is " Why do you have duplicates?"