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 6920Post New Covansys Interview Questions
Do you know is web sphere certified on people tools 8.1x?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the steps to use transact-sql cursor?
Is microservice stateless?
Define hybrid parameter?
how much maximum load a 2 core (Single phase) 16mm aluminium wire can take ?
hello guys, could you tell me the few difficult tickets that you have solved in SAP MM??
What is the advantage of using sticky keys?
Sell me this object?
What is remedy testing,expalim that and how can use that
explanation of mesh bus bars
How does phishing work?
What is BBP for an SAP FI consultant? p,lz answer it , maximum company ask dis as the first question.
how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance
Explain what is the difference between "revocable beneficiary" and "irrevocable beneficiary"? : insurance sales