CareerCup

I am not sure if I have understood the question correctly but If we want to delete initial two rows from table we can use

delete from table_name limit 2;

it will delete initial two rows.

DELETE FROM table
WHERE id in (SELECT TOP 2 * FROM table)

I just didn't find out any way to represent the database table in proper format, so i just used the <tr> tags!
I am representing here the table in horizontal format :
NAME : zac zac zac zac zac
LOCATION : california california california california california

Hello everyone,

I hope I got the solution for deleting the first two rows from Oracle table. Run below query in oracle

delete from emp where rowid in(select rd from(select aa.*, rowid rd from emp aa where rownum <3 order by rowid) abc) ;

Regards,

Note: Please correct/update me if found anything new

Not a DB guy, but giving it a try.

DELETE FROM <TABLE_NAME> WHERE <PK_COLUMN_NAME> IN (SELECT <PK_COLUMN_NAME> FROM <TABLE_NAME> WHERE ROWNUM<3)

Pretty Simple ---

delete from TABLE1 where rownum <=2

Is this table saved as a BLOB?

Psudocode(I will prefer to write it in C#, Python or Java because of the iterator constructs available, but choose language of your choice) :
Continue while (Counter_to_be_deleted)
1. We instantiate an iterator for the xml/json.
2. When you hit tr tag(tr tag encloses one record), delete the element, update counter_to_be_deleted = counter_to_be_deleted - 1

cant you just delete
2 of these rows?

<tr></tr>
<tr></tr>

done
tr means ROWS
hence the Table ROW initials TR

in sybase, you can use set rowcount

DELETE FROM TABLE WHERE ROWNUM<=2;

SELECT * FROM TABLE MINUS SELECT TOP 2 * FROM TABLE

DELETE FROM dbo.emp A
where A.empid in
(SELECT TOP 2 B.empid FROM dbo.emp B
MINUS
SELECT C.empid FROM dbo.emp C
)

delete top(2) from <tablename>