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 diff b/w load testing and volume testing?
what is difference between smoke testing and sanity testing?
What are the tools used by a tester while testing?
Hi,i am tester(qa) what technologies i have to learn to enhance my career..
What are the three C's for the present QA in the IT industry.
what is Software testing?
difference between qa and qc?
what is output of testplan?
in a team, how do u involve/test when ur modules are integrated to other modules of ur team.
What is binary portability testing?
what is Installation Testing?
What is the Difference between 2-tier and 3 tier applications... Anybody can explain in detail... Thanks in advance