ABSTRACT
This chapter is for advanced users. The main topics are Union, INTERSECT, EXCEPT, ROWNUM, Subquery, CASE and sequence. The readers will see the differences in Oracle SQL, T-SQL and MySQL statements. All the topics are covered with detail examples and outputs. By the end of the chapter readers will be able to use those advanced SQL skills in their workplace.
