sql - How to write the query that returns records where some column value appears more than once? -

I have a table that has columns with conditions

something like this:

< Table> from where (position id = 6) * select * from table 1 * I need to type in a query where some column values ​​appear more than once? & Gt;

You can write your query as follows:

 Table 1, where position id = SELECT * in position 1 (in selection ID (selection status, item number (*), AS CT, table 1 where position id = 6 Group status by Holding COUNT (*)> 1) AS TBL)  < / Ex>