Interested to Buy Any Domain ? << Click Here >> for more details...
how to achieve this problem?i am having table with two
colums like empno,gender.
in gender column, i am having records male,female like that
.my final output will be
male female
5 6
- 4 Answers
- 10057 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / shivaindu
SQL> select sum(decode(gender, 'male', 1)) as Male,
sum(decode(gender, 'female', 1)) as Female from
emp1;
MALE FEMALE
---------- ----------
9 7
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
How long it takes to learn pl sql?
What is trigger and how to use it in sql?
Can we create a trigger on view?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How do you explain an index number?
What is the difference between row level and statement level trigger?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is online transaction processing (oltp)? : Sql dba
Explain select statements in sql?
What is the usage of when clause in trigger?
What is the difference between alter trigger and drop trigger statements?
What has stored procedures in sql?
what is dbms? : Sql dba
What is right join in sql?
What is java sql package?
