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
- 5164 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
How can I know what locks are running on which resource?
Define self join?
What is the difference between drop table and truncate table?
What is deploy, process and build? : sql server analysis services, ssas
What are the key configuration files for sql server reporting services ?
How many servers can we create in a single subscription?
What is difference between delete and truncate commands?
do views contain data ?
What are the disadvantages of using the stored procedures?
What are indexers?
How sql server executes a statement with nested subqueries?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Can sql server be linked with other servers like oracle?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
what is a transaction? : Sql server database administration
