يك شنبه,۱۲ تير ماه ۱۴۰۱مطابق با
۳ ذيحجه ۱۴۴۳ هجرى قمرى

How find out …
Find duplicate rows
SELECT A.field FROM YOURTABLENAME A
WHERE rowid > (SELECT min(rowid) FROM YOURTABLENAME B WHERE B.field = A.field );
remove duplicate rows:
DELETE FROM YOURTABLENAME
WHERE rowid in
(SELECT rowid FROM
(SELECT rowid, row_number() over (partition by key order by key) dup FROM YOURTABLENAME)
WHERE dup > 1);
or
DELETE FROM YOURTABLENAME
WHERE rowid not in (SELECT MIN(rowid)
FROM YOURTABLENAME
GROUP BY column1, column2, column3…);
Tablespace of a table
SELECT YOURTABLENAME FROM all_tables
WHERE table_name = ‘YOURTABLENAME’;
See more website here...
Subpages
- صداقت دل
- Comedian World
- Wissenschaft
- Politik
- Songs & Videos
- Web Development projects
- Linux
Categories
- Ali Esteki (1)
- Blog (22)
- Electronic (12)
- iribTv (4)
- Linux (10)
- Ring Clock Project (4)
- Root (15)
- Tools (6)
- WordPress (6)
- اصفهان (چهارسوق) (2)
Leave a Reply