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
can u explain what is concurrancy in testing
What is 'Context Driven Testing' in Agile Method?
What do you like least about Quality Assurance/Testing?
Explain what is mr and what information does mr consists of?
anyone can explain about SixSigma process.
How do you train another QA engineer?
What is Comparision Testing?
hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?
What is role and responsibility of a senior software testing engineer in the company?( Day to day activities)
In an interview,the Interviewer asked me what are the reasons For the software has bugs? could u pls. explain the General reasons ..
5 Answers Infeneon Technologies,
What actually a SQA Tester do in His/ Her first (entry level) Job?
What is the rule of a "test driven development"?