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 / nani
select * from published book where min(age);
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is myisamchk?
What storage engines are used in MySQL?
How do I free up space in mysql?
What is 'mysqlshow'?
How do I edit a table in mysql?
What command is used to delete the data from the table without deleting the table structure?
What is difference between mysql_connect and mysql_pconnect?
What is longblob?
What is view? How can you create and drop view in mysql?
Difference between CHAR and VARCHAR?
what is a cursor? : Mysql dba
How many TRIGGERS are allowed in MySql table?
Can we rename database in mysql?
Explain the architecture models of SQL Server?
How do I restore a mysql database?