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?
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 is difference between materialized view and view?
What is bookmark link in ssrs?
How can delete duplicate records in cte in sql server?
How to define and use table alias names in ms sql server?
Explain about the command-line tool SQLCMD?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is a fill factor?
Explain magic tables in sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Write a sql query to delete duplicate records from a table called table1
what is the difference between count(*) and count(1) ?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
what happens on checkpoint? : Sql server database administration
What is used to replicate sessions between instances in coldfusion clusters?