Database

Muhammad Fahim Baloch wrote:

I want to Delete Duplicate records From a table except the Max(ID)

Muhammad Fahim Baloch wrote:

Using Full Text Query

Muhammad Fahim Baloch wrote:

Duplicate records are just certain field

Muhammad Fahim Baloch wrote:

I have millions of records in my table

Muhammad Fahim Baloch wrote:

I have Duplicate Email Addresses and i want to Delete Duplicate Email Addresses from my table except the max(emailId)

delete from YourTable
where exists (select 1
              from YourTable alias1
              where alias1.emailaddress = YourTable.emailaddress
              and   alias1.emailid      > YourTable.emailid)

Muhammad Fahim Baloch wrote:

and I have millions of Duplicate EmailAddresses in my table

SELECT     id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE '121' END AS m1

or

SELECT     id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE convert(varchar,121) END AS m1

<br />
select c.empid, c.dt as in1,  <br />
<br />
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'O'<br />
and not exists (select 1 from clock as c2 where c2.empid = c1.empid and c2.status = 'O' and c2.dt < c1.dt)) as out1,<br />
<br />
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'I'<br />
and c1.dt > c.dt) as in2,<br />
<br />
<br />
<br />
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'O'<br />
and c1.dt > (select c1.dt from clock as c1 where c1.empid = c.empid and status = 'I'<br />
and c1.dt > c.dt)) as out2<br />
<br />
from clock as c<br />
where c.status = 'I'<br />
and not exists (select 1 from clock as c1 where c1.empid = c.empid and c1.status = 'I' and c1.dt < c.dt)

Sovann wrote:

Thanks for your kindly to help me.

Sovann wrote:

but what you wrote is in query right ?

Sovann wrote:

It did not process

Sovann wrote:

but if there are more employee, Does it work ?

Sovann wrote:

My idea if we select and use for loop, what can we do ?