Refresh Your Java - Before Java Interview
We are Agile, believe in less Documentation - Only Quick notes (Java Interview Questions) of Java/J2ee Read more....
group by
select type, avg(price) from titles group by type order by avg(price)
having
sets conditions for the group by clause, similar to the way in
which where sets
conditions for the select clause.
having search conditions can include aggregate
expressions; otherwise, having search conditions are identical to
where search
conditions.
select pub_id,
total = sum(total_sales)
from titles
where
total_sales is not null
group by pub_id
having
count(*)>5
This Portal is intended to put all Java/J2ee related topics at one single place for quick referance, not only Technical , but also the Project Management Related thing such as Development Process methodoogies build process, unit testing etc.,
This Portal has More than 500 Java Interview Questions (also could be Considered as Quick Notes) very neatly separated topic by topic with simple diagrams which makes you easily understandable. Importantly these are from our Realtime expericance.