Latest Answer: UNION - returns on Distinct rows/Slower in performanceUNION ALLL- Returns duplicate rows/Faster Performance ...
Latest Answer: a materilized view can contain group function or some operators and it having some information . and it's useful in datawarehousing.. ...
Latest Answer: The main advantages of the triggers are* To Audit the table* To check the complex conditions which are not possible by the constraints. ...
Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table?
When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example?
Latest Answer: we can update a view using instead of trigger..... see example on url..http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls365.htm ...
Latest Answer: A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application ...
In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?
The main difference between the IN and EXISTS predicate in subquery is the way in which the query gets executed.IN -- The inner query is executed first and the list of values obtained as its result is
Latest Answer: In case of a big number of list from the select list IN operator should not be used but the exists shall be used with the proper condition this will definetely make the query optimal query. ...
Latest Answer: you can hide the table name by creating synonyms.e.g) you can create a synonym y for table xcreate synonym y for x; ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
