Oracle SQL Query/SubQuery Single column with mutilple data [closed]

Question

Id File-Name Descrption
1  yyyy      Started
2  yyyy      incompleted
3  rrrr      Started
4  tttt      started
5  uuuu      started
6  rrrr      completed
7  tttt      completed
8  uuuu      incompleted

A table having three rows where I need to write a query/condition to get all the completed records in that table.

Result should be

rrrr 
tttt

Select * from Table_name where file-name = start and file-name = complete;   ---It's not working...

Answer 1

You say the table has 3 rows but then you post 8 rows of data.

If I go by the text of your question, it sounds like you just want

SELECT *
  FROM table_name
 WHERE description = 'completed'

If I try to guess what you really want based on the SQL statement that you posted, my guess is that you want all the file names where there exists a row with a status of 'started' and a status of 'completed' (I am guessing that the 'Started' description from id values 1 and 3 are erroneously capitalized) then you would want

SELECT id, file_name
  FROM table_name
 WHERE description in ('started', 'completed')
 GROUP BY id, file_name
HAVING COUNT(distinct description) = 2

Answer 2

As you have only data like 'rrrr' and 'tttt' in file-name, checking for file-name = 'started' will never return any rows. Instead, you need something like:

SELECT t1.file_name
FROM
    table_name t1
    JOIN table_name t2 ON t1.file_name = t2.file_name
WHERE 
    t1.description = 'started'
    AND t2.description = 'completed'
;

But before jumping into copying queries from here, you should in first place get familiar with SQL syntax and technical terms like row, column, join, string literal and so on.