Interested to Buy Any Domain ? << Click Here >> for more details...
I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author?
- 3 Answers
- 5214 Views
- I also Faced
- E-Mail Answers
Answer Posted / mythili
select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Do you know what are pages and extents? : SQL Server Architecture
What is the difference function and stored procedure?
what are the disadvantages of cursors? : Sql server database administration
Explain how dts is used to extract, transform and consolidate data?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to select some specific columns from a table in a query in ms sql server?
What is filestream?
What is a field name?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How do I open a .db file?
What are the differences between decimal and float in ms sql server?
What are “phantom rows”?
How to modify existing triggers using "alter trigger"?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain in brief about Microsoft SQL server?
