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 SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

What is a trigger?

4 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers  

What is ms sql server index?

0 Answers  

Explain what is the main purpose of having conversation group?

0 Answers  

Explain triggers?

0 Answers  

What are wait types?

0 Answers  

What is the downside of using udf?

0 Answers  

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

Explain linked server in sql?

0 Answers  

How to find the version of sql server? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories