Database | SQL | PL- SQL Interview Questions
Write the complete query for Fetching the data from tables.
select column1, column2 ..
from table_name
where <condition>
group by <columns> having <conditions>
order by <columns>
Write the SQL for finding the second highest value.
mysql> select * from employee;
+---------+--------+
| name | salary |
+---------+--------+
| Dhiraj | 1000 |
| Dhiraj | 1000 |
| Kunal | 2000 |
| Aryan | 3000 |
+---------+--------+
mysql> select * from employee emp where 2=(select count(distinct salary) from employee where emp.salary>=salary);
+-------+--------+
| name | salary |
+-------+--------+
| Kunal | 2000 |
+-------+--------+
Write the code to find the duplicate records in a table.
mysql> select * from employee;
+---------+--------+
| name | salary |
+---------+--------+
| Dhiraj | 1000 |
| Dhiraj | 1000 |
| Kunal | 2000 |
| Aryan | 3000 |
+---------+--------+
mysql> select name,salary from employee group by name, salary having count(*)>1;
+--------+--------+
| name | salary |
+--------+--------+
| Dhiraj | 1000 |
+--------+--------+
What are DDL and DML?
select column1, column2 ..
from table_name
where <condition>
group by <columns> having <conditions>
order by <columns>
Write the SQL for finding the second highest value.
mysql> select * from employee;
+---------+--------+
| name | salary |
+---------+--------+
| Dhiraj | 1000 |
| Dhiraj | 1000 |
| Kunal | 2000 |
| Aryan | 3000 |
+---------+--------+
mysql> select * from employee emp where 2=(select count(distinct salary) from employee where emp.salary>=salary);
+-------+--------+
| name | salary |
+-------+--------+
| Kunal | 2000 |
+-------+--------+
Write the code to find the duplicate records in a table.
mysql> select * from employee;
+---------+--------+
| name | salary |
+---------+--------+
| Dhiraj | 1000 |
| Dhiraj | 1000 |
| Kunal | 2000 |
| Aryan | 3000 |
+---------+--------+
mysql> select name,salary from employee group by name, salary having count(*)>1;
+--------+--------+
| name | salary |
+--------+--------+
| Dhiraj | 1000 |
+--------+--------+
What are DDL and DML?
What is Join? Write the query for inner join.
What is natural join?
What is natural join?
What are the usage of Self Join?
What is outer join and what are the types of outer joins, explain briefly?
What are the differences between SQL, PL-SQL, Procedures & Triggers?
What are the differences between SQL, PL-SQL, Procedures & Triggers?
What are views and what are it's advantages?
What are the differences between Truncate and Delete command?
Comments
Post a Comment
Thank You for reading our post.
Your comment or feedback encourages us to improve the quality of content.
Don't forget to follow/subscribe to get the latest post.