Table name: T1, it has only one column.
I need the following output from the above base table by
using SQL query.
Answers were Sorted based on User's Feedback
Answer / dinakar
select col1,count(*) cnt from T1 where col1 in
(select distinct col1 from T1 )
group by col1
|Is This Answer Correct ?||1 Yes||6 No|
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
How to get second highest salary from a table
How to create your own reports in sql developer?
Explain the types of joins in sql?
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
What is the difference between union and union all command?
What are the benefits of pl/sql packages?
What are the two types of exceptions.
What is full join in sql?
What are the advantages of VIEW?
What is the difference between a subquery and a join?
What is procedure and function?