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

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

How can you append an identity column to a temporary table?

0 Answers  

What is difference between temp table and cte?

0 Answers  

Describe about first three Normal forms.

1 Answers   HP,

What is partition in sql server?

0 Answers  

What is sql injection and why is it a problem? : sql server security

0 Answers  

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

In the primary key have a multiple field or not?

8 Answers   TCS,

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

When to use Inner join & when to use subquery?

0 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories