TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Akhil Madivada
NA
58
7.5k
adding row from two tables and union two tbls to get top 4
Jul 25 2017 11:45 PM
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.
Reply
Answers (
2
)
Generate three rows dynamically based on data
Which datatype should be use to store sign number?