Table name: T1, it has only one column.
I need the following output from the above base table by
using SQL query.
Answer Posted / vinu
select decode (col1,'a','a','b','b','others') col1,count(col1) from T1 group by decode (col1,'a','a','b','b','others')
|Is This Answer Correct ?||9 Yes||2 No|
how are mysql timestamps seen to a user? : Sql dba
what is oracle database ? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is the difference among union, minus and intersect?
what is auto increment? : Sql dba
What are the parameter modes supported by pl/sql?
What is the advantage of index in sql?
How do I edit a trigger in sql developer?
How to get list of all tables from a database?
how to check server status with 'mysqladmin'? : Sql dba
Can a composite key be null?
Why is theta join required?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is program debugging?