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
Latest Answer: SELECT salespersonid, orderamount FROM orders WHERE orderamount IN (SELECT orderamount FROM orders ORDERBY orderamount DESC) WHERE rownum
Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads
Does View occupy memory? If we delete the base table of existing view, What happens?
Latest Answer: Actually view is a stored select statement and its code is stored in data dictionary. It doesn't occupy space in the memory. whenever view is called, the stored select statement executes and fetches the data from the base table.If base table is deleted, ...
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
Latest Answer: Where clause is used for restricting the conditions of SQL statements.Having clause is used for group by functions. ...
Latest Answer: As per 10g Version, the maximum limit is 255 ...
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10
Latest Answer: UPDATE table_name SET maxmarks=(SELECT CASE maxmarks WHEN mark1>marks2 THEN mark1 ELSE mark2 end FROM table_name) ...
Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed
Latest Answer: CREATE TABLE emp2ASSELECT substr(ename,instr(ename,',')+1) First,substr(ename,1,instr(ename,',')-1) Last FROM emp1; ...
what is difference between nested query,sub query and nested query? explain clearly with an example?
Latest Answer: query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.
Nested subquery runs only ...
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let
Latest Answer: If you do not know the column name you want to select from the table, I would simply suggest you that, follow this command:
SELECT * FROM table_name
here * let you choose all the column name from the respective table. ...
Latest Answer: You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because dual is basically used to work with scalar query. If ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
