Scribd
Upload
12 views1 page

SQL Questions

The document outlines various SQL concepts including types of indexes, triggers, joins, query optimization, and constraints. It also provides specific SQL query examples for tasks such as fetching employee details, handling duplicates, and using subqueries. Additionally, it discusses differences between SQL commands and clauses, as well as performance considerations in query execution.

Uploaded by

mahi.p4505
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
12 views1 page

SQL Questions

The document outlines various SQL concepts including types of indexes, triggers, joins, query optimization, and constraints. It also provides specific SQL query examples for tasks such as fetching employee details, handling duplicates, and using subqueries. Additionally, it discusses differences between SQL commands and clauses, as well as performance considerations in query execution.

Uploaded by

mahi.p4505
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

[Link] of indexes ?

why do we use indexes in sql


[Link] is trigger ? trigger creation syntax and advantage ?
[Link] SQL Query with Joins.
[Link] do you optimize complex SQL queries?
[Link] are the point to consider if the query is delaying in fetching data from a
table/s ?
[Link] to find the details of employee with Maximum total salary
[Link] are constraints in sql
[Link] related to employee and departent with join conditions
[Link] is the Primary key
[Link] is composite primary ;key in sql
[Link] query to fetch all the employees who are not working on any project.
[Link] an SQL query to fetch a project-wise count of employees.
[Link] an SQL query to fetch all the Employees who are also managers.
[Link] an SQL query to fetch duplicate records from EmployeeDetails.
[Link] an SQL query to fecth the nth highest or lowest salary from employeesalary
[Link] between Having and Where clause.
[Link] between alter and update command.
[Link] between deop and delete and truncate
[Link] we use Where clause after the group by?
[Link] is more efficient subquery or join. Explain with example?
[Link] is faster inner join or left outer join? Why?
[Link] a query to fetch the alternate record from a table.
[Link] a query to display the all records whose name contain character ‘a’ in
2nd and 5th position.
[Link] a query to display the 3rd highest salary from Employee table.
[Link] a query to display the record by joining multiple table.
[Link] a query while using subquery and join both in a single query
[Link] a query to show your age in reference to current date displaying years,
month and days. Format – Y years M months D days.

You might also like