There must be some column such as 'TECHNOLOGY' that should disti

I have one table,in that table
(1)i have java1.1 version books are 2 and java1.5 version
books are 4.
(2).Net2.0 books are 3, .Net3.5 books are 2
(3)ABC1.6 books are 4, ABC2.0 books are 3.

Now i want output is like

Book Count

Java 6
.Net 5
ABC 7

For this i need sql query, please help me if anyone how to
get this result.

Thanks,
Seenu

Question Posted / oraclecodec

4 Answers
6802 Views
Adea, I also Faced
E-Mail Answers

Answer Posted / oraclecodec

There must be some column such as 'TECHNOLOGY' that should
distinguish java ,.net and ABC apart from their versions.
Then its easier to arrive at a solution

SELECT TECHNOLOGY,COUNT(*) FROM BOOK GROUP BY TECHNOLOGY;

Is This Answer Correct ?

8 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does varchar include?

944

How do you modify a table in sql?

1118

What is data manipulation language?

1185

Why do we use procedures in sql?

1068

How to assign sql query results to pl sql variables?

1072

What are few of the schema objects that are created using PL/SQL?

1028

Can we use ddl commands in pl sql?

1156

What is a function in oracle pl sql?

1035

How does stored procedure reduce network traffic?

1005

Can we enter data in a table in design view?

965

what is schema? : Sql dba

1044

What is the advantage of index in sql?

966

Can we create clustered index without primary key?

962

Mention what is the use of function "module procedure" in pl/sql?

1047

How do I start sql from command line?

1019