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 basis set?
Web 2.0 Style Software Testing Management System- any suggestions? I'm looking out for a Web2.0 based software with features which makes test management easy. The feature I expect to see are; dashboards, live updating, reporting and communication system.
SDLC Phase ==> Requirements feasibility study --> understanding of design / architecture --> development of DFD/Use Case diagrams / Stories etc --> development --> v&V --> Acceptance. Request you all to identify all possible artifacts created during SDLC phases.
How can you describe QA process in your last company?
My Nokia is 3806 CMDA. It is always heat and the battery is down.Why is it happening ?
What is a test plan and what does it include?
what is exploratory Testing?
10 Answers ABC, Kiran Prakashan, Ordain Solutions,
list the type of testing you think must be conducted on web application project
What are the various tools you have used in testing process?
find the odd man out in below testing techniques. a.loadtesting b.stress testing c.recovery testing d.integration testing also tell me why?
Which institute in hyderabad is good for ETL testing? Please suggest
what is Bottle Neck testing??