Why do we use triggers?
No Answer is Posted For this Question
Be the First to Post Answer
What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
what is blob? : Sql dba
What are the types of SQL Statement?
Write a sql query to get the third highest salary of an employee from employee_table?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is TABLE SPACE?
i need department wise top 2 employees salary.which logic i will use
What is a primary key? Explain
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
How will you select unique values from a list of records?
What is procedure function?