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 |
I want to find out all databases starting with ‘test’, I have access to?
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
Why are function needed?
How can we get total number of records by query in mysql?
What is mysqli procedural?
What is datadir?
How to create a test table in your mysql server?
How will show all records containing the name "sonia" and the phone number '9876543210'
Why mongodb is faster than mysql?
What are the column comparisons operators?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
How to include numeric values in sql statements?