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 8063Post New Covansys MySQL Interview Questions
Is ajax still in use?
Is redshift can be used with AWS RDS?
What is css1?
What is frequentist?
Explain the two uses of blocking an account? : fi- general ledger accounting
Explain something you know about normalization? : hana administration
How to pronounce postgresql?
What are Non-additive facts?
What is a hyperlink example?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How are data structures handled by ntfs and how does it recover from a crash?
Explain the remapping method calls in codeigniter.
What is model form in django?
Specify different types of decision control statements?
Does crystal reports can be built on top of UDT?