Answer Posted / ram
many number of tables can be join in a sql query by using 'join'
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is null in pl/sql?
List the ways to get the count of records in a table?
What is the maximum number of columns in sql table?
What is a heap in sql?
Can we create foreign key without primary key?
Is sql a case sensitive language?
Where not exists in sql?
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.
what is “go” in t-sql? : Transact sql
Is it possible to link two groups inside a cross products after the cross products group has been created?
How bulk collect improves performance?
How do I truncate a sql log file?
How to find 3rd highest salary of an employee from the employee table in sql?
How to pipe multiline string to isql?
what is a composite key ? : Sql dba