Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
2
Reply
adding row from two tables and union two tbls to get top 4
Akhil Madivada
Jul 25 2017 11:45 PM
250
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Generate three rows dynamically based on data
Which datatype should be use to store sign number?