Testing your basic SQL statements (1) Please write a SQL Statement to retrieve a

Question

Testing your basic SQL statements

(1)

Please write a SQL Statement to retrieve all records from all of the tables above

(2)

Account_Info contains all records in the system
Account_Removal contains all removed records in the system
Please write a SQL statement to retrieve only records that are not in the Account_Removal table

(3)

(4)

Using any of the sql statement above, please prompt a Javascript/JQUERY alert where the ID is an even number in the HTML HEAD section and display records where ID is odd number in any web development language in the HTML BODY section.

(5)

Account_Info Account_Info_ID auto number Account_Info_Name varchar2(100) Account_Removal Account_Removal_ID auto number Account_Removal_Name varchar2(100) Account_Potential Account_Potential_ID auto number Account_Potential_Name varchar2(100)

Please write a SQL Statement to retrieve all records from all of the tables above

(2)

Account_Info Account_Info_ID auto number Account_Info_Name varchar2(100) Account_Removal Account_Removal_ID auto number Account_Info_ID number Account_Removal_Name varchar2(100)

Account_Info contains all records in the system
Account_Removal contains all removed records in the system
Please write a SQL statement to retrieve only records that are not in the Account_Removal table

(3)

Testing the integration between SQL and any web development language Using any of the sql statement above, please output the records in any web development language and HTML View Data Name My Name Retrieve from Account Info table in Edit Mode Modification History Modified By Date Modified 12/16/2008 16:28:16 PM Compare with currentfile Name 1 121 6/2008 16:25:15 PM Compare with current file Name 1 1216/2008 16:21:11 PM Compare with current file Name 1 Save Record Retrieve from Account History Info table End Result from the display all records related to the editing record from the Account History table when EDITING the record at the bottom of the screen. Please produce the end result and paste it in the text box

Explanation / Answer

select A1.Account_info_ID, A1.Account_info_Name, A2.Account_Removal_ID, A2.Account_Removal_Name, A3.Account_Potential_ID, A3.Account_Potential_Name FROM Account_info A1, Account_Removal A2,Account_Potential A3 WHERE A1.Account_info_ID=A2.Account_Removal_ID and A1.Account_info_ID= A3.Account_Potential_ID;

select A1.Account_info_ID, A1.Account_info_Name FROM Account_info A1, Account_Removal A2 WHERE A1.Account_info_ID=A2.Account_info_ID ;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.