Is foreign key mandatory?
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.
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
Is pl sql better than sql?
What is information schema in sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
what are the different functions in sorting an array? : Sql dba
Which one is better sql or oracle?
How do you pronounce sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
what is an alias command? : Sql dba
What is a temporal data type?
What is a Procedure ?