Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
15 40630how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
11 14807i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
8 11025TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?
10 13245Post New Satyam SQL PLSQL Interview Questions
what are the characteristics of Class Members in C++?
What are various storage types permitted by openstack compute?
What is java virtual machine and how it is considered in context of java’s platform independent feature?
. Give the C language equivalents of the following a)Function returning an int pointer b)Function pointer returning an int pointer c)Function pointer returning an array of integers d)Array of function pointer returning an array of integers
How to call java method in jsp page on button click?
Who is father of wordpress?
How do I create a database in access 2010?
Is node.js is free?
How many scope does camel error handler have?
Explain the different layers of Cloud Computing?
How molecular taxonomy has affected bacterial classification?
Briefly describe the role of global.asax?
Explain JSON Values?
What do you know about mongodb?
What is as_view in django?