Forum

Write a sql query r...
 
Share:
Notifications
Clear all

Write a sql query resort located In jaipur display the resort name and the manager Name

2 Posts
2 Users
0 Likes
1,009 Views
Rahul Updhyay
Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 2 years ago

Write a query to display the resort name and its manager name for the resort located at jaipur. sort by resort name.

1 Reply
FA User
Posts: 36
 FA User
Guest
(@FA User)
Eminent Member
Joined: 2 years ago

Here is the query to display the resort name and its manager name for the resort located at jaipur order by the resort name.

Select a.ResortName, b.name as ManagerName
From
Resort a,
Manager b
Where
a.managerID=b.managerID
AND
b.city= "JAIPUR"
Order by ResortName
Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: