Table name: T1, it has only one column.
I need the following output from the above base table by
using SQL query.
Answer Posted / vikneswaran
select decode(col1,'a','a','b','b','Other') "col1",count
from col group by col1;
|Is This Answer Correct ?||0 Yes||2 No|
Why is a trigger used?
What is using in sql?
Is sql a oracle?
What are the uses of sysdate and user keywords?
How to write a query to show the details of a student from students table whose
explain the difference between bool, tinyint and bit. : Sql dba
Does mysql support pl sql?
How many sql statements are used? Define them.
How can a function retun more than one value in oracle with proper example?
how do you login to mysql using unix shell? : Sql dba
What is db journal file?
How is data stored in sql?
What are few of the schema objects that are created using PL/SQL?
What is an emotional trigger?
What are the two types of cursors in pl sql?