SQL query help please

[vikram]

no place
1 hyd
2 nzb
1 nzb
3 abc
1 bbc
3 xyz

i want output
no place
1 hyd
1 nzb
1 bbc
3 abc


3 xyz

[SltPhx]

Hey Vikram,
Is there any reason why you eliminated
2 nzb
in the output?
I am assuming that here, place is a unique field, and can be in the output only once?

[vikram]

Hey Vikram,
Is there any reason why you eliminated
2 nzb
in the output?
I am assuming that here, place is a unique field, and can be in the output only once?

Place is NOT a unique field, it can be in the output more than once.
i want to display numbers(no) in more than one place.

no place
1 hyd
2 nzb
1 nzb
3 abc
1 bbc
3 xyz
1 nzb

i want output
no place
1 hyd
1 nzb
1 nzb
1 bbc
3 abc
3 xyz

[vikram]

some one please reply ...

[SltPhx]

Vikram,
Could you please explain based on what criteria you want to display your result?
Why is it that you eliminated 2 NZB?

[vikram]

Hi SltPhx ...

Vikram,
Could you please explain based on what criteria you want to display your result?
Why is it that you eliminated 2 NZB?

No - Field / Integer
Place - Field / Text
query should display all NO and PLACE

Condition
- if NO is present in more than one PLACE

* 2 NZB => [NO] 2 is only present at one particular [PLACE] NZB. Other numbers are present in more than one place.