Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / guest

Answers were Sorted based on User's Feedback



I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author..

Answer / mythili

select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )

Is This Answer Correct ?    3 Yes 0 No

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author..

Answer / vrinda

SELECT t1.PUBID,t3.AuthorName
FROM Publisher t1 join Title t2
on t1.PUBID = t2.PUBID
join Author t3
on t3.AuthorID = t2.AuthorID.

Is This Answer Correct ?    3 Yes 1 No

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author..

Answer / 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

More SQL Server Interview Questions

What is proper subset of candidate key?

0 Answers  

How do clustered indexes store data?

0 Answers  

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

How to retrieve field values using mssql_result()?

0 Answers  

What is change data capture (cdc) in sql server 2008?

0 Answers  

How can you find out how many rows returned in a cursor?

0 Answers  

What is the full form of ddl?

0 Answers  

Which is the latest version of sql server and when it is released?

0 Answers  

What are binary string data types in ms sql server?

0 Answers  

How to use user defined functions in expressions?

0 Answers  

What is bit data type?

0 Answers  

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories