Trash - 2017-03-11

« first day (134 days earlier) ← previous day next day → last day (2616 days later) »

12:43 AM

Q: How to select a specific row based on another row from same table

I have a table with duplicated rows, I want to select only one row out of many that has a field populated in it. Example: +--------+------+---------------+ | id | col1 | col2 | +--------+------+---------------+ | 111111 | 9 | Not Specified | | 111111 | 1 | Green ...

It was about delete rows, not select

No, sorry

Can I delete comments here?

ypercubeᵀᴹ

@McNets which ones?

McNets

@ypercubeᵀᴹ this is it

MSSQL, Yes, Once I have the values for col1, col2 for the specific id i no longer need the id with the unspecified information and i would like to delete it. — user119472 2 hours ago

Yes, the question was about delete records.

ypercubeᵀᴹ

1:01 AM

@McNets I meant which comments you want deleted? We can do that for you.

McNets

No, I want to delete my previous comments here about this question: dba.stackexchange.com/questions/166893/…

But, when I answered it, it was about delete duplicate records, not about select duplicate records.

ypercubeᵀᴹ

→ 7 messages moved to Trash

← 7 messages moved from The Heap™ – Consultancy ©®

McNets

MSSQL, Yes, Once I have the values for col1, col2 for the specific id i no longer need the id with the unspecified information and i would like to delete it. – user119472 1 hour ago

ypercubeᵀᴹ

→ 1 message moved to Trash

← 1 message moved from The Heap™ – Consultancy ©®

I wonder if I can relocate the relocation messages