-
Hi
Need little help here, trying to write an SQL that do as follows
have two tables and when I join them I would get something like
Column A---Column B
New York----David
New York----John
New York----Alex
Atlanta-------Chris
Florida-------Phil
L.A-----------David
L.A-----------Jenny
L.A-----------Boris
L.A-----------Joseph
Miami--------Alex
Miami--------Will
Now I want the query to return just a limited rows using rownum, for example
where rownum <= 3
However this would return
Column A---Column B
New York----David
New York----John
New York----Alex
ONLY
But I need all results of first column <= 3, what i am saying is that I need the query to return me
Column A---Column B
New York----David
New York----John
New York----Alex
Atlanta-------Chris
Florida-------Phil
where column A has 3 values
is this possible at all? I have seek a few ways but cant do it!!!
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|