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
- 8374 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Difference between CHAR and VARCHAR?
What is unique key in mysql?
How many ways we can retrieve the date in result set of mysql using php?
How to include character strings in sql statements?
What is mysqlcheck do?
How to dump one database for backup.
How do I edit a database in mysql workbench?
How can you see all indexes defined for a table?
What is cursor in mysql?
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 do I truncate all tables in mysql?
How to delete a database from mysql server.
What is mysql vs sql?
Why use mysql procedures?
What is the use of count function in mysql?
