Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / manoranjan sethy
You can create a view without taking the assistance of base table but base table signature must be required while creating of force view.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
explain mysql aggregate functions. : Sql dba
How to rename a table?
What are the 3 modes of parameter?
what is a materialized view? : Sql dba
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
Do ddl statements need commit?
Can triggers stop a dml statement from executing on a table?
what is foreign key? : Sql dba
What is numeric function sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is a string data type in sql?
Does db2 use sql?
What are the different types of functions in sql?
what is the difference between char_length and length? : Sql dba
What is program debugging?
