sql - Adding row from two tables and union the two tables to get top 4 paying high fee -


i having 2 tables same column names(studentname, fee) 2 tables want add 1 row both tables i.e., row having studenname 'kay'(shown in below image) , top 4 students paying high fee.

how write sql query required output image shown below.

enter image description here


Comments

Popular posts from this blog

Ansible warning on jinja2 braces on when -

Parsing a protocol message from Go by Java -

html - How to custom Bootstrap grid height? -