Latest Answer: There can be as many as all the number of columns of the table which can be used in the GROUP BY clause. Oracle Server handle of this itself. ...
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10
Latest Answer: SQL> update student set maxmarks=greatest(m1,m2);I took 'student' as the 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 emp2 as(select Substr(ename,1,instr(ename,',')-1) as last, substr(ename,instr(ename,',')+1,length(ename)) as first from emp1) ...
what is difference between nested query,sub query and nested query? explain clearly with an example?
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: We can not select a particular column values without knowing it's name. However, we can select all the columns from a table using the following statement.SELECT * FROM table_name; ...
Latest Answer: The answer depends on release. Before 10g it was possible, starting with 10g - no. ...
WE using Last_value()analytical function but the result do not match according to me?
How and in what way REPLACE is different from TRANSLATE?
Latest Answer: REPLACE: It is used to replaces the value,without giving the alternative letter or word.Ex:1. select replace(ename,'S') from emp; 2.select replace(ename,'S','A') from emp;TRANSLATE: Here you must apply ...
What are Column Level Constraint and Table Level Constraint? How do they differ from one another?
Latest Answer: Table level constraint:Ex: create table emp(empno integer,ename varchar(20),deptno integer,primary key(empno))column level constraint:create table emp(empno integer primary key,ename varchar(20),deptno integer)In table level need create constraint ...
Latest Answer: Use below queryselect unique * from table_name; ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
