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
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 to run a sql statement?
What is prepare statement in mysql?
Can mysql scale horizontally?
How does select query work?
Can mysql function return a table?
What is the limit of mysql database?
How do I restore a mysql database?
What is difference between mysqli and pdo?
How to include numeric values in sql statements?
How to create a table index in mysql?
What is the full meaning of mysql?
How to Change a users password from unix shell.
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How to set mysql variable in php?
What is a storage engine? What are the differences between innodb and myisam engines?