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
- 8377 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / sagar
Q 3) Select lb.author,count(b.books) as total_books from
books b, library_mgmt lb where b.author = lb.author group
by books having total_books >1;
Q 4) select b.author from books b where year(b.publish_date)
not in('2006');
Q5) Select b.author from books b ,author a where year
(a.birthdate) = year(b.publish_date) and a.author=b.author;
Q6) Select b.books from books b where year(b.publish_date)in
('2007') and (b.title like '%India%' or b.language='hindi');
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the common mysql functions?
What is 'mysqladmin' in mysql?
Is mysql same as sql?
What is key in mysql?
What does mysql_query return?
What is a result set object?
What, if a table has one column defined as TIMESTAMP?
how can you test for null values in a database? : Mysql dba
How to create trigger in mysql phpmyadmin?
How do I rename a procedure?
What are the 'mysql' command line arguments?
How does mysql store dates?
What is a trigger in mysql?
What is the use of mysqli_fetch_array?
How to print message in mysql trigger?
