Search results
Select rollno, count (rollno) from Student. Group by rollno. Having count (rollno)>1. Order by count (rollno) desc; 4.How to find Third highest salary in Employee table using self-join? (90% asked Complex SQL Interview Questions ) Answer: Select * from Employee a Where 3 = (Select Count (distinct Salary) from Employee where a.salary<=b.salary;
Mar 27, 2017 · select * from Employee where To_char (Joining_date,’YYYY’)=’2017′; MS SQL: select * from Employee where substr (convert (varchar,Joining_date,103),7,4)=’2017′; CLICK HERE TO GET 20 Most important Complex SQL Queries.. 11.What is mean by Sequence in database? (80 % asked in Interview Questions for TCS) Answer: Use the CREATE SEQUENCE ...
1.Tricky SQL Queries and Interview questions. 2.Video for tricky interview queries. Tricky SQL Queries for interview : Question 1 : What is query to fetch the employee records where salary of employee is greater than 57 k and less than 75 k? Answer : There are two different solutions to achieve this , Solution 1 : Using Between..and operator
Complex SQL Queries Examples with answers : Following are some very important complex sql queries examples with answers.I have tried to explain each and every query in detail so that everyone will get idea of how it is executed step-by-step.Following are some Complex SQL Queries Examples with answers in detail.
Oct 26, 2017 · Answer : The first normal form is the normal form of database where data must not contain repeating groups.The database is in First normal form If, 1.It contains only automic values. Automic values:- The Single cell have only single value. 2.Each Record needs to be unique and there are no repeating groups.
Apr 2, 2018 · The most tricky interview questions in PL SQL are those with Stored Procedure Interview Questions.A stored procedure or in simple a proc is a named PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages.Following are some important stored procedure interview questions:
known organization and it has some tricky interviews.I will try to cover the Tricky interview questions which will probably asked in SQL Interview of Deloitte.You need to give English versant test if you successfully completed and shortlisted from the interview. Following are some Interview Questions for Deloitte which will ask for SQL,PLSQL,ETL
Nov 29, 2017 · 1.Other users can see the data changes made by the transaction. 2.The locks acquired by the transaction are released. 3.The work done by the transaction becomes permanent. Rollback : When transaction become wrong user can rollback the data. 1.The work done in a transition is undone as if it was never issued.
Nov 26, 2018 · 1.SQL Stands for Structured Query Language which is a database programming language. 2.Oracle SQL stands for SQL used to do the database programming in Oracle. 3.Larry Ericsson is the father of oracle who has started the company in 1977. 4.The following is step-wise evaluation of different Oracle versions.
Apr 19, 2022 · 1.A self-join can be an inner join or an outer join or even a cross join. 2.A table is joined to itself based upon a column that have duplicate data in different rows. Question 14 : What is query to display employee name, his job, and his manager. Display also employees who are without a manager.
