There are 2 tables: EMP : EmpId, Ename, Sal, DeptId DEPT : DeptId, Dname Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows ?No Department?. Write a query to find out those department names which has no employee. Write a query to find out those employees whose salary is greater than their department?s average salary.
1 6460I have thousands of links are there, i want check each and every funtionality of link by using descriptive programme, retrive link name from excelsheet then operate in application. Please anybody send me model script
1 4306Q1: What is RAS ? is RAS and VPN the same ? Q2: How do i determine that my computer is connected to the right network and is getting a valid ip ?
8 56893Post New Oracle Interview Questions
What is truncate linux?
How to write a query with a left outer join in oracle?
What is apache flume used for?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What is difference between put and post method in http?
manhole height is 1500 mm and width of brickwork is 230 mm dia of manhole covering is 560 mm brick masonry 1:4 horizontal length is 1500 mm and plaster 12 mm thick on both side 1:3. how to estimate the quantity of brickwork with mortar cement and sand for manhole chamber.
How do I find the difference between two numbers in excel?
Suppose there is check box along with the rows. The requirement is, select the require check boxes and press a used defined button to save all these checked row data to another table. How can you do it?
What are the events recorded in a transaction log?
Mention what are the different types of custom settings in salesforce?
What is a dynamic route in angularjs and how do you implement it?
What is Multipoint-to-Multipoint connection?
What are the differences between sql server and mysql.
How to use earthing on shipments.
What are the five challenges you faced in QTP?