Loading

adding row from two tables and union two tbls to get top 4

Akhil Madivada

9y929SQL

I am having two tables with same column names(studentName, fee) from the two tables I want to add one row from both the tables i.e., the row having studenName as 'KAY'(shown in the below image) and get the top 4 students who are paying the high fee.

How to write a SQL Query to get my required output as the image shown below.

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pramod Thakur9y ago
You can write query like this.
select  top 4 * from  (
        select * from table1
        union all
        select * from Table2
        ) as StudentData
order by Fee desc
Mark as answer if you find helpful.
Puneet Kankar9y ago
you use union between two table query and find top 4 student order by fee desc .