Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
15 40766how 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 14909i 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 11093TABLE 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 13340Post New Satyam SQL PLSQL Interview Questions
Can you write a programmer for FACTORIAL using recursion?
What is normalization? Describe its different types.
List various types of interrupts available in 8051 microcontroller?
How to work definite,over pluxing,revers power,OSR relay
Tell us what is social bookmarking?
What is Mapper? How can we compress Mapper output in Hadoop?
What is catalina?
Where is the sum function in excel?
Explain why diesel engine is known as high torque and petrol engine as high speed engine?
What are the causes of emergency stop in a steam engine?
What is the difference between mechine.config and web.config?
Explain how to convert json text to a javascript object?
What is
Explain the tuning lookup transformation - informatica
Why can we not create directory /user/dataflair/inpdata001 when name node is in safe mode?