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
- 7188 Views
- Covansys, I also Faced
- E-Mail Answers
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 cte? : Mysql dba
Is sql similar to mysql?
What are the mysql database files stored in system ?
What is the default port for mysql and how it can change?
What is the usage of ENUMs in MySQL?
What is the data source name for mysql?
What is the difference between a heap table and temporary table?
What is the purpose of -> in the mysql terminal?
What is information_schema in mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
Does mysql support sequence?
How do you rename a table?
How do I enable mysqli extension?
What is truncate in mysql?
Is mysql owned by oracle?
