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
|