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
- 8067 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 is the return type of mysqli_query?
What is 'mysqlshow'?
Can we write pl sql mysql?
What is truncate in mysql?
What are the disadvantages of mysql?
What language is used in mysql?
Why we use mongodb instead of mysql?
How much does mysql cost?
Why mysql is used with php?
What is mysql_query?
How do you create a primary key?
How can I remotely connect to mysql database?
What is data types in mysql?
What are the advantages of myisam over innodb?
Is mysqli secure?
