Practice
x
Practice
  • Explore
  • Courses
  • Get Hired
  • Login

Message

Error

Note: For issues in your code/test-cases, please use Comment-System of that particular problem.

×
account_circle
lock
Forgot Password
email
lock
business
or
Google
Facebook
Why Create an Account?
By creating this account, you agree to our Privacy Policy & Cookie Policy.

Please enter your email address or userHandle.

account_circle
Back to Login

  • Popular Company Tags
    • Amazon
    • Microsoft
    • Oracle
    • Samsung
    • Adobe
    • Synopsys
    • Infosys
    • Cisco
    • Wipro
    • Ola-Cabs
    • Morgan-Stanley
    • Goldman-Sachs
    • show more
  • Popular Topic Tags
    • Maths
    • Array
    • Dynamic-Programming
    • Greedy-Algorithm
    • Hashing
    • Tree
    • Bit-Algorithm
    • Matrix
    • Backtracking
    • Operating System
    • Linked-List
    • Graph
    • show more

  • Subjective Problems
Problem Name Answers  Views  Company Tags
How would you find the second largest salary in table? 54 5567 TCS
Write a query to find the name and department of the employee with highest salary 18 4789 Oracle
What are the basic data types in sql? 16 2198
Data Control Language (SQL) 16 1879
How to design a student database? 13 3091 Amazon
How to get nth max salaries? 12 2813 Oracle
Single Test case vs Multiple Test cases 11 2843
How would you Select FIRST n records from a table? 9 2156 Oracle
Diff. between trigger and stored procedure? 6 3046 Deloitte
What are DML and DDL statements? 5 1471 Zomato
How would you Select LAST n records from a table? 5 2619 Oracle
How to select random record from a table? 5 1200
What is RAW datatype? 5 2390 Oracle
Write SQL query to find Nth largest salary of employee? 4 2228 Oracle
What is SQL? 4 1251 Infosys
Write a query to find 3rd lowest salary ? 4 1537 Opera
How can you select all the even number records from a table? All the odd number records? 3 1242
Write a query to create a clone of existing table without using create command? 3 1350
What is an outer join? 3 2394 Infosys
SQL Trigger 3 2052 Philips
How to create index in sql ? 3 1098 clicklabs
Difference between JOIN and UNION? 2 2791 Oracle
Sql query to find id of second highest score in a table with ids and scores. 2 1873 SAP Labs
Which one is more efficient a Join operation or a nested query? 2 4252 Goldman Sachs
Return the average salary for each department in SQL? 2 2652 IBM
What is Aggregate Functions? 2 1263 symantec
Stored Procedure - SQL 2 1559 Philips
What is trigger? 2 1287 Philips
Why should we use CTE? 2 1305
What is SQL Server Agent? 2 1169
Difference between varchar and varchar2 data types? 2 3135 Oracle
What is COALESCE function? 2 2682 Oracle
What Is "mysqlshow"? 2 1588 axtria
When is the use of UPDATE_STATISTICS command ? 2 1488
Write a SQL query using UNION ALL (not UNION) that uses the WHERE clause to eliminate duplicates. 1 1580
What is an execution plan? 1 965
What are the NVL and the NVL2 functions in SQL? How do they differ? 1 998
What is the difference between the RANK() and DENSE_RANK() functions? Provide an example. 1 1162
How to insert into a table with just one IDENTITY column? 1 1072
How to create a UNIQUE Key on a Column which is having multiple NULL values? 1 1251
Which is better a CTE or a subquery? Why? 1 1067
What are the magic tables? Do we have “Updated” magic table? 1 1045
What is the difference between sub query and correlated query 1 2081
How to connect a java code to a database? 1 1917 Oracle
Difference between SQL and PL/SQL ? 1 1607 D-E-Shaw
SQL Query to find students taking more than one class 1 1444 Morgan Stanley
What is Two phase locking in sql? 1 1508 Expedia
How to Identify slow queries? 1 1149 Expedia
What are some predefined exceptions in PL/SQL? 1 1208 Wipro
What is an inner join in SQL? 1 1201 Infosys
Unique integrity without using Primary Key or Unique constraint 1 1193 Infosys
What do you meant by active and passive objects? 1 1627 Expedia
Difference between delete and truncate in SQL? 1 1195 Synopsys
difference between Stored procedure and triggers in sql ? 1 1399 Amdocs
What is CTE? 1 1330 symantec
What are the Advantages of using CTE? 1 1416 symantec
What is PIVOT and UNPIVOT? 1 1335 symantec
What is Dirty Read ? 1 1610 symantec
Inner and Outer Join 1 1060 Philips
What is FSMO role ? 1 1167 CGI
What are advantages of trigger? 1 1276 Philips
What is SQL sequence? 1 1128 Xome

Message

Error

Please report if you are facing any issue on this page.

Note: Please use this button to report only Software related issues. For queries regarding questions and quizzes, use the comment area below respective pages.
  • GeeksforGeeks
  • 5th Floor, A-118,
  • Sector-136, Noida, Uttar Pradesh - 201305
  • feedback@geeksforgeeks.org
  • COMPANY
  • About Us
  • Careers
  • Privacy Policy
  • Contact Us
  • LEARN
  • Algorithms
  • Data Structures
  • Languages
  • CS Subjects
  • Video Tutorials
  • PRACTICE
  • Courses
  • Company-wise
  • Topic-wise
  • How to begin?
  • CONTRIBUTE
  • Write an Article
  • Interview Experience
  • Internships
  • Videos
@geeksforgeeks, Some rights reserved