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
- 5254 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
What is BLOCK statements in SQL?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are the differences between DDL, DML and DCL in SQL?
Where is localdb stored?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is difference between inner join and join?
How can we solve concurrency problems?
Do you know what are the properties of the relational tables?
What is sql server replication? : sql server replication
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
What are examples of triggers?
Which are new data types introduced in sql server 2008?
How to recreate an existing index in ms sql server?
How do you drop an index?
