Search results
- Write a SQL query to fetch “FIRST_NAME” from the Student table in upper case and use ALIAS name as STUDENT_NAME. SELECT upper(FIRST_NAME) as STUDENT_NAME from Student;
- Write a SQL query to fetch unique values of MAJOR Subjects from Student table. SELECT DISTINCT MAJOR from STUDENT; or SELECT MAJOR FROM STUDENT GROUP BY(MAJOR);
- Write a SQL query to print the first 3 characters of FIRST_NAME from Student table. SELECT SUBSTRING(FIRST_NAME, 1, 3) FROM Student;
- Write a SQL query to find the position of alphabet (‘a’) int the first name column ‘Shivansh’ from Student table. SELECT INSTR(FIRST_NAME, 'a') FROM Student WHERE FIRST_NAME = 'Shivansh';
- What Are The Constraints in Sql?
- What Are The Differences Between OLTP and OLAP?
- What Is Collation? What Are The Different Types of Collation Sensitivity?
- GeneratedCaptionsTabForHeroSec
Constraints in SQL are rules or conditions that you can apply to the columns of a table to add data integrity and support the accuracy and consistency of the data stored in the database. Moreover, it help ensure that the data meets certain criteria and prevent incorrect or inconsistent data from being inserted, updated, or deleted. Here are some co...
OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are distinct database architectures with different purposes. OLTP focuses on managing day-to-day operational data and handling transactional workloads in real time. It involves frequent small updates, insertions, and deletions. On the other hand, OLAP is designed for compl...
Collation in a database context refers to the rules governing how string comparison and sorting operations are performed on character data. It determines how characters are compared, whether they are treated as case-sensitive or case-insensitive, and how accented or special characters are treated. Collation sensitivity refers to how a collation tre...
Learn 20 common SQL query interview questions and answers with examples and reference tables. Prepare for SQL queries interview questions based on data management, manipulation and analysis.
- 10 min
- Write an SQL query to fetch the EmpId and FullName of all the employees working under the Manager with id – ‘986’. We can use the EmployeeDetails table to fetch the employee details with a where clause for the manager-
- Write an SQL query to fetch the different projects available from the EmployeeSalary table. While referring to the EmployeeSalary table, we can see that this table contains project values corresponding to each employee, or we can say that we will have duplicate project values while selecting Project values from this table.
- Write an SQL query to fetch the count of employees working in project ‘P1’. Here, we would be using aggregate function count() with the SQL where clause-
- Write an SQL query to find the maximum, minimum, and average salary of the employees. We can use the aggregate function of SQL to fetch the max, min, and average values-
Jan 2, 2024 · Check out the most commonly asked SQL Query Interview Questions ranging from basic to advanced SQL queries for freshers and experienced professionals (2 to 10 years).
Feb 15, 2024 · Prepare for your SQL interview with this comprehensive guide that covers general and technical questions for job hunters and hiring managers. Learn about SQL flavors, commands, statements, functions, queries, and more.
Prepare for your SQL interview with these challenging questions and solutions from Toptal, a network of freelance developers. Learn how to use UNION, JOIN, EXISTS, RANK, and more in SQL queries.
People also ask
What questions do SQL interviewers ask?
How to write SQL query interview questions for Freshers?
How to answer technical SQL interview questions?
Why do SQL query interview questions matter?
May 29, 2024 · Prepare for your SQL interview with over 100 questions and exercises, organized by topic and difficulty level. Learn SQL basics, advanced topics, and tips to ace your coding exercises on various platforms.
