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
How do you know that your test cases will meet the requirement that the client required for the application.
What is the base Criteria to review the testcases?
Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.
What are the testing techniques? pls let me know in detail
What is the test ware?
What are the attributes of a good software qa engineer?
What is base concept of QA against usability Issues
whatis the diff. between Tracebility matrix and Bidirectional Tracebility matrix?
What is random testing?
What is the exact different between QA and QC?
What do you like most about Quality Assurance/Testing?
Can you help me with your suggestions so as to select a test management system that fits perfectly well with the two widely used software development methodologies i.e., agile and waterfall?