hi,
they have given 2 tables to write quries in SQL SERVER 2000
based on table as follows .
1st table :author:
COLUMNS AS FOLLOWS
pk. AUTHOR
F_NAME
DOB
NATIONALITY
2ND TABLE BOOKS:
COLUMNS AS FOLLOWS;
PK ISDN
F.K AUTHOR
LANGUAGE
PUBLISH_DATE;
1) RETRIVE author who is indian and hindi
write in a) as joins b) sub quries
2)retrive who is younger author ;
3)retrive author who wrote more than one book in different
language.
4)retrive author who has wrote in different language in
each year
write all queries in sql for sql server
No Answer is Posted For this Question
Be the First to Post Answer
What is Bidirectional Traceability and how it is achieved?
What should your qa documents include?
Negative testcases for salary application..
How can you introduce new software qa processes to an existing organization?
Q. How do you select product components for validation?What are the contents of QMS?
what is the role of QA in all the phases of SDLC?
3 Answers Infosys, Value Labs,
List out the difference between Verification and Validation.
1) What r the properties, Advantages & Disadvantages of each types of action? 2)When I can use this?
What is the difference between Test cases document and test cases design document?
what r the techniques to design test cases?
4 Answers Thatavarti Technologies,
How to log defect in HP ALM
Anything you know about host file