Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
15 41159how 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 15281i 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 11357TABLE 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 13603Post New Satyam SQL PLSQL Interview Questions
What is automatic and direct replenishment?
Why do we need to write test classes?
Tell us how do classification and regression differ?
What are javascript objects?
Can we connect to postgresql using sql developer?
What is windows azure traffic manager? What are its benefits?
Which is the parent class of the web server control?
who are the major stake holders in software integration
What is ibm aix?
How to create a ddl trigger using "create trigger" statements?
What are the critical scenarios in production support? Tell me some examples?
What are the advantages of using rpa mobile app in automation anywhere?
What does ruby name refer to?
What is storage management in operating system?
What is the default size of master database in sybase?