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 7629Post New Covansys Interview Questions
how to convert sand in Cft to Kgs
What is the embryonic origin of the nervous system in vertebrates?
Which is faster mongodb or mysql?
Tell me what is laravel eloquent?
I am facing problem in infotype 0019/ monitoring of task. Pls help me in doing it 0019 working, the system is not giving the reminder on set date, is it require some other settings also. Pls let me know what all settings need to be done for this infotype?
Differentiate null and void?
How many ways can you make beans in spring?
What is annotated documentation?
What phenomenon becomes when air mixed with refrigerant?
Highlight the differences between Primary Key and Primary Index.
How do you use merge sort?
Can multiple cursors being opened at the same time?
What is a timer job?
What are differentiations of the cell membrane?
Explain relational data?