-
How do you handle this DB Schema changes in our Framework manager to update automatically our meta data
I have created meta data model using Cognos FM and later source data base column were changed but DBA was not informed the changes. How to handle this DB Schema changes in our Framework manager to update automatically our meta data.
-
-
-
-
-
-
-
Find out nth highest salary from emp table
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);For Eg:-Enter value for n: 2SAL---------3700
-
What is difference between Rename and Alias?
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.