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
6689 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 are the different parts of a package?

1063

What is the process of debugging?

1026

what is heap table? : Sql dba

1067

What is right join sql?

932

What is execute immediate?

1030

Is sql better than access?

982

What type of join is sql join?

931

Does pl sql work in mysql?

939

What are the possible values for the boolean data field?

917

What is composite data type in pl sql?

1051

What do you mean by field in sql?

1049

What are all the different normalizations?

987

What is sp_helptext?

1023

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3018

Does execute immediate commit?

1170