how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?
9 20830Post New Deloitte SQL Server Interview Questions
- Deloitte Programming Languages AllOther Interview Questions (2)
- Deloitte JavaScript Interview Questions (1)
- Deloitte TCP IP Interview Questions (1)
- Deloitte C Sharp Interview Questions (1)
- Deloitte ASP.NET Interview Questions (3)
- Deloitte Dot Net Framework Interview Questions (1)
- Deloitte Dot Net General Interview Questions (14)
- Deloitte Microsoft Related AllOther Interview Questions (1) Deloitte SQL Server Interview Questions (3)
- Deloitte SQL PLSQL Interview Questions (2)
- Deloitte Unix Commands Interview Questions (1)
- Deloitte QTP Interview Questions (11)
- Deloitte Manual Testing Interview Questions (11)
- Deloitte Mobile Testing Interview Questions (1)
- Deloitte Test Cases Interview Questions (1)
- Deloitte Testing AllOther Interview Questions (1)
- Deloitte COBOL Interview Questions (3)
- Deloitte JCL Interview Questions (1)
- Deloitte DB2 Interview Questions (2)
- Deloitte Core Java Interview Questions (3)
- Deloitte Servlets Interview Questions (1)
- Deloitte Teradata Interview Questions (2)
- Deloitte Business Objects Interview Questions (3)
- Deloitte Cognos Interview Questions (2)
- Deloitte Informatica Interview Questions (21)
- Deloitte Data Stage Interview Questions (1)
- Deloitte SAS Interview Questions (1)
- Deloitte Data Warehouse General Interview Questions (2)
- Deloitte HR Questions Interview Questions (30)
- Deloitte SAP ABAP Interview Questions (44)
- Deloitte SAP SD (Sales & Distribution) Interview Questions (26)
- Deloitte SAP MM (Material Management) Interview Questions (1)
- Deloitte SAP PP (Production Planning) Interview Questions (3)
- Deloitte SAP FI-CO (Financial Accounting & Controlling) Interview Questions (11)
- Deloitte SAP BW (Business Warehouse) Interview Questions (1)
- Deloitte SAP Security Interview Questions (4)
- Deloitte SAP Business One Interview Questions (1)
- Deloitte Siebel Interview Questions (1)
- Deloitte Oracle Apps Technical Interview Questions (5)
- Deloitte Oracle Apps Financial Interview Questions (28)
- Deloitte Oracle Apps SCM Interview Questions (2)
- Deloitte Salesforce Interview Questions (15)
- Deloitte Cloud Computing General Interview Questions (3)
- Deloitte Bio Informatics Interview Questions (1)
- Deloitte Mechanical Engineering Interview Questions (2)
- Deloitte Business Administration Interview Questions (1)
- Deloitte Banking Finance Interview Questions (12)
- Deloitte Human Resources Interview Questions (9)
- Deloitte Audit Interview Questions (6)
- Deloitte CompanyAffairs CS Interview Questions (1)
- Deloitte Taxation Interview Questions (7)
- Deloitte Accounting General Interview Questions (10)
- Deloitte Accounting AllOther Interview Questions (33)
- Deloitte Call Centre AllOther Interview Questions (4)
- Deloitte General Knowledge_Current Affairs Interview Questions (1)
- Deloitte Everything Else AllOther Interview Questions (6)
- Deloitte General Aptitude Interview Questions (5)
- Deloitte Placement Papers Interview Questions (3)
- Deloitte CISA Certification Interview Questions (1)
- Deloitte MAT Interview Questions (1)
What do you mean by independent suspension?
What is the central organizational element in purchasing?
What does char * * argv mean in c?
Can we deploy applications to different servers?
Does salesforce stores the deleted objects and fields? : salesforce objects & fields
What is the use of Ownership while creating Entity in MSCRM?
What is php and sql used for?
When a company distributes the catalog of products manufactured by other companies, what will be the main responsibility to ensure the accuracy of the contentmentioned in the catalog?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How to check a featured image exists or not in wordpress?
Is udp better than tcp?
What is the use of jdbctemplate in spring?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
what is difference between normalization and denormalization. in normalization all tables are normalizad format or not. what r the types of indexes are there. what is difference b/w bitmap,b-tree,unique and function based indexes.
What does a production rule consist of?
