-
User-defined Data Type
Write an SQL statement to create user-defined data types?
-
Create View
Write an SQL statement to create views.
-
Number of Constraints
How to count the number of constraints on a given table?
-
Display Middle Record
How to display middle record in a given table?
-
Department Wise Average Salary
How to query the average salary for all the departments employing more than 3 people?
-
Average Monthly Salary
Write a query to display the average, monthly salary bill for each job type within a department.
-
Change Default Display
How to change the default display? For deptno 10 show "Financial Department", for deptno 20 show "Account Department", for deptno 30 show "Management Information System", for deptno 40 show "Electronic Data Processing"
-
Highest Average Salary
Construct a query which finds the job with the highest average salary