Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 8258 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / sagar
Q 3) Select lb.author,count(b.books) as total_books from
books b, library_mgmt lb where b.author = lb.author group
by books having total_books >1;
Q 4) select b.author from books b where year(b.publish_date)
not in('2006');
Q5) Select b.author from books b ,author a where year
(a.birthdate) = year(b.publish_date) and a.author=b.author;
Q6) Select b.books from books b where year(b.publish_date)in
('2007') and (b.title like '%India%' or b.language='hindi');
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to Return total number of rows.
What is a user defined variable?
Explain triggers and stored procedures?
How do I run mysql?
What is the difference between truncate and delete?
Is mysql workbench a dbms?
What are the technical features of MySQL?
In which language it is written?
Can you tell which of the following where clauses is faster?
What ascii 31?
What is mysql root?
How to convert dates to character strings?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
How do I disable mysql?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
