What does the SELECT * statement do in Oracle?
Why should you be cautious when using SELECT * in production queries?
How do you limit the number of rows returned by a SELECT * query in Oracle?
How can you use SELECT * with a WHERE clause in Oracle?
How do you handle NULL values when using SELECT * in Oracle?
How can you join multiple tables using SELECT * in Oracle?
What are the performance implications of using SELECT * in complex queries?
How do you use SELECT * in a subquery in Oracle?
How do you use SELECT * with analytic functions in Oracle?
Explain a scenario where using SELECT * might cause issues and how to resolve it.
How can you query the hierarchy of employees in a company using the SELECT statement in Oracle?
How can you use SELECT * to retrieve all employees and their direct managers?
How can you use SELECT * to fetch the entire hierarchy under a specific manager?
How can you include the hierarchy level of employees using SELECT *?
How can you use SELECT * to find only employees without subordinates (leaf nodes)?
To fetch ALTERNATE records from a table. (EVEN NUMBERED)
To select ALTERNATE records from a table. (ODD NUMBERED)
Find the 3rd MAX salary in the emp table.
Find the 3rd MIN salary in the emp table.
Select FIRST n records from a table.
Select LAST n records from a table
List dept no., Dept name for all the departments in which there are no employees in the department.
How to get 3 Max salaries ?
How to get 3 Min salaries ?
How to get nth max salaries ?
Select DISTINCT RECORDS from emp table.
How to delete duplicate rows in a table?
Count of number of employees in department wise.
Suppose there is annual salary information provided by emp table. How to fetch monthly salary of each and every employee?
Select all record from emp table where deptno =10 or 40.
Select all record from emp table where deptno=30 and sal>1500.
Select all record from emp where job not in SALESMAN or CLERK.
Select all record from emp where ename in 'BLAKE','SCOTT','KING'and'FORD'.
Select all records where ename starts with ‘S’ and its lenth is 6 char.
Select all records where ename may be any no of character but it should end with ‘R’.
Count MGR and their salary in emp table.
In emp table add comm+sal as total sal .
Select any salary <3000 from emp table.
Select all salary <3000 from emp table.
Select all the employee group by deptno and sal in descending order.
How can I create an empty table emp1 with same structure as emp?
How to retrive record where sal between 1000 to 2000?
Select all records where dept no of both emp and dept table matches.
If there are two tables emp1 and emp2, and both have common record. How can I fetch all the recods but common records only once?
How to fetch only common records from two tables emp and emp1?
How can I retrive all records of emp1 those should not present in emp2?
Count the totalsa deptno wise where more than 2 employees exist.
Query to find second highest salary of Employee
Find nth maximum salaries
Fetch ALTERNATE records from a table. (EVEN Numbered)
Select First n records from a table
Select Last n records from a table
Delete Duplicate Rows in a table
Count MGR and their salary in employee table
Add comm+salary as total salary
Retrieve record from salary between 1000 to 2000
Retrieve department-wise totalsalary for departments with more than 2 employees