| How would you find the second largest salary in table? |
54 |
5086 |
TCS
|
| Write a query to find the name and department of the employee with highest salary |
18 |
4326 |
Oracle
|
| What are the basic data types in sql? |
16 |
1906 |
|
| Data Control Language (SQL) |
16 |
1540 |
|
| How to design a student database? |
13 |
2885 |
Amazon
|
| How to get nth max salaries? |
12 |
2545 |
Oracle
|
| Single Test case vs Multiple Test cases |
11 |
2181 |
|
| How would you Select FIRST n records from a table? |
9 |
1967 |
Oracle
|
| Diff. between trigger and stored procedure? |
6 |
2736 |
Deloitte
|
| What are DML and DDL statements? |
5 |
1196 |
Zomato
|
| How would you Select LAST n records from a table? |
5 |
2397 |
Oracle
|
| How to select random record from a table? |
5 |
1030 |
|
| What is RAW datatype? |
5 |
2154 |
Oracle
|
| Write SQL query to find Nth largest salary of employee? |
4 |
1911 |
Oracle
|
| What is SQL? |
4 |
1119 |
Infosys
|
| Write a query to find 3rd lowest salary ? |
4 |
1332 |
Opera
|
| How can you select all the even number records from a table? All the odd number records? |
3 |
996 |
|
| Write a query to create a clone of existing table without using create command? |
3 |
1155 |
|
| What is an outer join? |
3 |
2083 |
Infosys
|
| SQL Trigger |
3 |
1861 |
Philips
|
| How to create index in sql ? |
3 |
952 |
clicklabs
|
| Difference between JOIN and UNION? |
2 |
2482 |
Oracle
|
| Sql query to find id of second highest score in a table with ids and scores. |
2 |
1664 |
SAP Labs
|
| Which one is more efficient a Join operation or a nested query? |
2 |
3822 |
Goldman Sachs
|
| Return the average salary for each department in SQL? |
2 |
2239 |
IBM
|
| What is Aggregate Functions? |
2 |
1127 |
symantec
|
| Stored Procedure - SQL |
2 |
1378 |
Philips
|
| What is trigger? |
2 |
1149 |
Philips
|
| Why should we use CTE? |
2 |
1138 |
|
| What is SQL Server Agent? |
2 |
1026 |
|
| Difference between varchar and varchar2 data types? |
2 |
2746 |
Oracle
|
| What is COALESCE function? |
2 |
2441 |
Oracle
|
| What Is "mysqlshow"? |
2 |
1392 |
axtria
|
| When is the use of UPDATE_STATISTICS command ? |
2 |
1300 |
|
| Write a SQL query using UNION ALL (not UNION) that uses the WHERE clause to eliminate duplicates. |
1 |
1386 |
|
| What is an execution plan? |
1 |
830 |
|
| What are the NVL and the NVL2 functions in SQL? How do they differ? |
1 |
874 |
|
| What is the difference between the RANK() and DENSE_RANK() functions? Provide an example. |
1 |
1002 |
|
| How to insert into a table with just one IDENTITY column? |
1 |
931 |
|
| How to create a UNIQUE Key on a Column which is having multiple NULL values? |
1 |
1098 |
|
| Which is better a CTE or a subquery? Why? |
1 |
913 |
|
| What are the magic tables? Do we have “Updated” magic table? |
1 |
921 |
|
| What is the difference between sub query and correlated query |
1 |
1787 |
|
| How to connect a java code to a database? |
1 |
1789 |
Oracle
|
| Difference between SQL and PL/SQL ? |
1 |
1471 |
D-E-Shaw
|
| SQL Query to find students taking more than one class |
1 |
1285 |
Morgan Stanley
|
| What is Two phase locking in sql? |
1 |
1384 |
Expedia
|
| How to Identify slow queries? |
1 |
1034 |
Expedia
|
| What are some predefined exceptions in PL/SQL? |
1 |
1100 |
Wipro
|
| What is an inner join in SQL? |
1 |
1095 |
Infosys
|
| Unique integrity without using Primary Key or Unique constraint |
1 |
1081 |
Infosys
|
| What do you meant by active and passive objects? |
1 |
1396 |
Expedia
|
| Difference between delete and truncate in SQL? |
1 |
1059 |
Synopsys
|
| difference between Stored procedure and triggers in sql ? |
1 |
1236 |
Amdocs
|
| What is CTE? |
1 |
1208 |
symantec
|
| What are the Advantages of using CTE? |
1 |
1180 |
symantec
|
| What is PIVOT and UNPIVOT? |
1 |
1194 |
symantec
|
| What is Dirty Read ? |
1 |
1439 |
symantec
|
| Inner and Outer Join |
1 |
918 |
Philips
|
| What is FSMO role ? |
1 |
1021 |
CGI
|
| What are advantages of trigger? |
1 |
1127 |
Philips
|
| What is SQL sequence? |
1 |
995 |
Xome
|