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 5261

Post New Covansys MySQL Interview Questions









Un-Answered Questions

What is Drupal error handling?

7


USE OF 8 WAY PAN ASSEMBLY

960


What are the three factors that can affect your cash flow and business profitability?

110


How do I control formatting and appearance?

92


we are having 15kw and 3kw motor both can run in same time , instead of using copper we are using ug aluminium cable , 35 sq.mm is suitable for its current carrying capacity..?

738






What do you know about device context?

80


What type of metrics would you use?

1140


What is a microsoft visual c++ 2008 redistributable?

49


How do you change the scale on excel?

1


How will you enable SMTP on Application Server?

471


Why we use routing in angularjs?

29


What happens if chkdsk is interrupted?

29


What is an interpolation in perl?

68


What are the Alerts & Subscriptions?

42


I wish to create a windows application to perform a similar function as that of the "Search" which is provided to look for related files and folders in the System.. What steps must i follow??

1052