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
- 4234 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 authentication modes does sql server support?
What is sql stored procedure?
What are the characteristics of modern DBMS?
What is 2nf normalization?
What is a transact-sql statement batch in ms sql server?
How to reaname table name without using sp_Rename in sql server..?
What are system databases into sql server (2005/2008)?
Explain the properties of the relational tables?
Define outer join in sql server joins?
How to provide login information for a new odbc dsn?
What is xdr?
What is sql server agent and what are the two modes of authentication in sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
