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 4574Post New Covansys Interview Questions
Explain the construction of the conservator, operation and purpose, and draw the diagram of the conservator.
in our co we are sales of good to branch in order sales+fright, branch made jv entry in own book as full amount debit and credit. now our book show sales without freight but branch shows including freight that why differences is arise due to wrong entry passes pls clarify this entry and this entry is done last year book now balance is finalize.
wht is charging gateway protocol wht is it functio
HOW TO CONVINCE CUSTOMER IN INSURANCE BPO JOB?
What are the various forms used for VAT?
Hello, How is T code OBXZ different from OBXL? Also, how to use T code OBXZ.
Why dissolution test is not performed in all of the products
What is a brake horse power?
Pressure tx shows 1 mbar but we need 1000 mbar at this process condition .. how can we sort it out .
hi friends pls forward impropmtu interview question
What is morphology-based operations?
hi , can you Suggest me the books (with author names) to learn Network programming from basics. Thanks in Advance... Prakash
why you want this job (specially when you go for first interview and changing the industries)
if main CT is of ratio 50/5, and meter CT is -/5 what will be overall multiplying factor of meter.PT is 11000/110 .
what are the effects of price increase? How do you manage price rise and maitain company markert share?
- C++ General (1)
- PHP (1)
- Crystal Reports (1)
- SQL Server (1)
- MySQL (1)
- DB Development (1)
- WinRunner (2)
- Load Runner (1)
- QTP (13)
- Test Director (1)
- Rational TestSuite (5)
- Automation Testing AllOther (4)
- Manual Testing (42)
- QA Concepts (6)
- Test Documents Reporting (1)
- Testing AllOther (1)
- COBOL (4)
- CICS (1)
- Core Java (2)
- JDBC (1)
- XML XSLT RSS (2)
- Cognos (5)
- SAP ABAP (1)
- Oracle Apps Technical (2)
- SeeBeyond (1)
- General Knowledge_Current Affairs (1)
- Aptitude Questions (1)
- Placement Papers (1)
