COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Assume that you have the following:CREATE FUNCTION totalPaidByCust(custID INT) ____ ENDIf you want to query the function, the command will be:
|
|
CALL totalPaidByCust(3);
|
|
|
SELECT totalPaidByCust(3);
|
|
|
EXECUTE totalPaidByCust(3);
|
|
|
None of the answer is correct
|
Explanation:
Detailed explanation-1: -SQL AS keyword is used to give an alias to table or column names in the queries.
Detailed explanation-2: -To create Tables in SQL, we must have the table’s name, the column’s name, the data type of the column, and the size ( size is used to define the maximum length of data that can be input into the column).
Detailed explanation-3: -The asterisk (*) selects all the column names in all the tables specified by the from clause. Use the asterisk to save typing time and errors when you want to see all the columns in a table. When you use the asterisk in a query, data is retrieved in create table order.
There is 1 question to complete.