-
ALTER Row
We are UPDATING a field in SQL and ALTER the row also. After giving the COMMIT command the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table or not?
-
Produce a List of 5 Highest Revenue Transactions
You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:CREATE TABLE Orders ( OrderID Int IDENTITY NOT NULL, SalesPersonID Int NOT NULL, RegionID Int NOT NULL, OrderDate Datetime NOT NULL, OrderAmount Int NOT NULL ) Which statement will produce the report correctly?...
-
Package Function
You have a package called A and one function in that packgae called XYZ.If you need to call that function in second packaged B, How will you call?
-
Analytical Function
WE using Last_value()analytical function but the result do not match according to me?
-
-