1) Select Count(1) From Dual;,What Is Output?
Answer : 1
2) How to delete duplicate records from table without Distinct Clause
Answer: Using row id
drop table Employee;
create table Employee(id int,name varchar2(10),sal int);
insert into Employee values(1,'Vishnu',2300);
insert into Employee values(1,'Vishnu',2300);
insert into Employee values(1,'Vishnu',2300);
insert into Employee values(1,'Vinay',4500);
insert into Employee values(3,'Teja',4500);
insert into Employee values(4,'Ashwin',1100);
insert into Employee values(5,'Raj',45000);
select...
12/26/2019
12/05/2019
Real Time Scenarios of ORACLE SQL Development - 4
How to find Nth Highest salary in a Team.
Queries:
drop table Employee;
create table Employee(id int,name varchar2(10),sal int);
insert into Employee values(1,'Vishnu',2300);
insert into Employee values(2,'Vinay',4500);
insert into Employee values(3,'Teja',4500);
insert into Employee values(4,'Ashwin',1100);
insert into Employee values(5,'Raj',45000);
select * from Employee;
2nd maximum salary in Employee table.
select...
12/02/2019
Real Time Scenarios of ORACLE SQL Development - 3
Dealing with Duplicate records from a table using Row Number Function.
drop table student;
create table student(id int,name varchar2(10),dept int);
insert into student values(1,'Vishnu',111);
insert into student values(1,'Vishnu',111);
insert into student values(2,'Teja',222);
insert into student values(3,'Ashwin',222);
insert into student values(3,'Ashwin',222);
select * from student;
ROWNUM and ROWID keywords in ORACLE.
ROWNUM...