ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories >> Software >> Databases >> MySQL
 
 
 
Question
SQL:
1.	Write a queryto retrieve the author who was 
published a book at the youngest age?
2.	write a query to retrieve the no. of books 
published a each year in various languages?
3.	write a query to retrieve no. of books published by 
them only those authors who have published more than 1 book?
4.	write a query to retrieve who has not published any 
books during the year 2006?
5.	write a query to retrieve the authors who has 
published any books during the birth date  write this query 
in 2 ways 1)joins 2)sub query
6.	write a query to retrieve all the books which was 
published during jan 2007 & title containing India or 
published in the language hindi?


  1. table name is liberary managemnt and two column is 
there one is authors and another one is books .
2.four fields will comes under authours like nationality, 
birthdate ,first-language,second-language
3.four fields will comes under books like 
authour,title ,language,publish date  to write query using 
this details
 Question Submitted By :: Sureshasall
I also faced this Question!!     Rank Answer Posted By  
 
Answer
select * from published book where min(age);
 
0
Nani
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com