Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT b.cim,b.nev,r.cegnev,r.kibocsatas,r.nevertek,r.arfolyam
- FROM befekteto b,tranzakcio t,reszvenytipus r,(
- SELECT * FROM (
- SELECT befekteto.befektetoid AS azon,COUNT(reszvenytipus.rtid) AS darab
- FROM befekteto,tranzakcio,reszvenytipus
- WHERE (befekteto.befektetoid =tranzakcio.befektetoid) AND (reszvenytipus.rtid= tranzakcio.rtid) AND (reszvenytipus.rtid=0)
- GROUP BY befekteto.befektetoid
- ORDER BY darab DESC)
- WHERE ROWNUM = 1) t1
- WHERE (t1.azon =b.befektetoid) AND (r.rtid = 0) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement