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
- 5364 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan p
select [Publiser ID] from Title where [Author ID] in(select
[Author ID] from Author where [Author Name]='AuthorName')
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are entities and relationships?
Explain boyce and codd normal form(bcnf)?
What is the use of commit?
Mention the 3 ways to get a count of the number of records in a table.
how can a database be repaired? : Sql server administration
What is constraints and its types?
Explain different types of locks in sql server.
How to create a stored procedure with a statement block in ms sql server?
How many levels of sp nesting are possible?
Will sql server 2005 allow you to reduce the size of a column?
how can u get last observation in an unknown dataset ?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Is it safe to delete log files?
Does table partitioning improve performance?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
