Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8378 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / vijay
select count(a.books),year(b.publish date)as
Year_Published,language from library management a,books b
where a.authour=b.authour group by Year_Published;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can I create a database in mysql?
How do I find mysql version in mysql workbench?
How do I find my mysql username and password?
How to update database permissions/privilages.
What is a simple query?
What are the advantages of myisam over innodb?
What is sqlyog?
How do I start mysql in linux?
How can you validate emails using a single query?
Is mysql written in c?
Which mysql function is used to concatenate string?
What is mysql ndb?
What does mysql_query return?
What is the password of mysql?
Is oracle better than mysql?
