Union and Union All Concept in SQL
Difference between Union and Union All select * from XX_STUDENT_TL STUDENT_NAME MARKS PHYSICAL_MARKS RESULT GRADE Amit 33 80 F A Bharat 20 30 F Jai Prakash 99 100 P A++ Manoj 20 98 F A+ Pinky 90 30 P A+ Rahul 45 55 Ravi 50 90 P A+ Sanjay 80 40 P A+ --==================================================== UNION --==================================================== select * from XX_STUDENT_TL where RESULT = 'P' UNION select * from XX_STUDENT_TL WHERE GRADE = 'A+' STUDENT_NAME MARKS PHYSICAL_MARKS RESULT