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
- 5171 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
How to make remote connection in database?
What is the difference between primary key and unique constraints?
What is cube dimension? : sql server analysis services, ssas
List the types of recovery model available in sql server?
Explain the usage of floor function in sql server.
what is database replication? : Sql server database administration
What is read uncmmited?
What is the purpose of the model database?
What command must you use to include the not null constraint after a table has already been created?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are recommended options to be used while using db mirroring? : sql server database administration
What do you understand by a stored procedure?
What are the differences between char and nchar in ms sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
