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
6628 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 is meant by urlencode and urldocode? : Sql dba

1088

What are the two different parts of the pl/sql packages?

1023

What is left join example?

886

How do I use google cloud in sql?

1026

How many types of triggers are there in pl sql?

1006

What is case function?

985

explain access control lists. : Sql dba

946

How do I run a sql query in pgadmin 4?

904

What is offset in sql query?

1068

What is scope and visibility in PL/SQL?

1109

what is a trigger in mysql? Define different types of trigger. : Sql dba

1008

Cite the differences between execution of triggers and stored procedures?

1026

Mention what are different methods to trace the pl/sql code?

1096

Does sql*plus have a pl/sql engine?

994

how to dump a table to a file with 'mysqldump'? : Sql dba

981