Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Covansys MySQL Interview Questions
Questions Answers Views Company eMail

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 6834

Post New Covansys MySQL Interview Questions




Un-Answered Questions

What is the best server?

487


How do you insert a comment in microsoft word 2010?

301


WHAT DO YOU MEAN BY ASN ?

1457


What are pre-processor elements? List some of the elements.

314


What are the properties of analytic view? : hana administration

108






I want to control database connections in my program and want that only one thread should be able to make database connection at a time. Define how can I implement this logic?

567


State the limitations where we cannot use joiner in the mapping pipeline?

526


Define what is the difference between active and passive filters?

1368


Can any body worked in QA in Finincail / Trading experience. i appreciate if you ans my some questions.

1551


What is the size of array float a(10)?

624


What can you do to improve your conversion rates?

172


What is the use of bootstrap in zend framework?

198


what are the tables used in health care domain project and columns used in report?

4014


Can you stop multiple submits to a web page that are initiated by clicking to refresh button?

466


what is the system function to get current user's user id? : Sql server database administration

526