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
- 8379 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
How do I start mysql in linux?
How does limit work in mysql?
Is oracle mysql free?
How do I check mysql version?
What is dbms in mysql?
What is delimiter in mysql trigger?
What are the applications required to support mysql?
What is mysqli_select_db?
What is the maximum size of table in mysql?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
Is mysql a programming language?
How can I see connections in mysql?
What are the common mysql functions?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
