Is grant a ddl statement?

896

What is sql exception?

974

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.

2619

Is inner join same as self join?

1116

What is difference between group by and partition by?

1060

How do you explain an index?

1282

What are the two characteristics of a primary key?

976

what are the t string functions available in tsql? : Transact sql

1008

What is a temporal data type?

1052

What is sql basics?

1042

what is a stored procedure? : Sql dba

1132

What is a memo field?

969

Is a foreign key always unique?

942

Is oracel sql developer written in java?

1105

what is isam? : Sql dba

1008