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
Answers were Sorted based on User's Feedback
Answer / vijay
select count(books),year(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 ? | 4 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How do you connect MySQL database with PHP?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is unsigned in mysql?
How do I select a database in mysql?
How do you name a table?
Is mysql relational?
Is there a way to see the files which are stored?
What is the use of mysql workbench?
How to returns the columns and column information pertaining to the designated table.
How to start mysql server?
Can you shard mysql?
How do you shutdown a mysql database?