BUSINESS ADMINISTRATION
BUSINESS POLICY
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
DateOfPurchase
|
|
CustomerID
|
|
ProductDetails(1)
|
|
TotalCost
|
Detailed explanation-1: -2) Which of the following is not a valid SQL type? Explanation: DECIMAL is not a valid SQL type because it is nothing but numeric only in SQL.
Detailed explanation-2: -SQL Not Equal Operator: != The SQL Not Equal comparison operator (!=) is used to compare two expressions. For example, 15 != 17 comparison operation uses SQL Not Equal operator (!=)
Detailed explanation-3: -If != and <> both are the same, which one should be used in SQL queries? Here is the answer – You can use either != or <> both in your queries as both technically same but I prefer to use <> as that is SQL-92 standard.
Detailed explanation-4: -In SQL null is not equal ( = ) to anything-not even to another null . According to the three-valued logic of SQL, the result of null = null is not true but unknown.