| 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
|