Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Sush_post1
create table sample_3(identy integer , Person text) with oids; insert into sample_3 values(101, 'Raju'); insert into sample_3 values(102, 'Kiran'); insert into sample_3 values(103, 'Praveen'); insert into sample_3 values(101, 'Raju'); insert into sample_3 values(104, 'Aditi'); insert into sample_3 values(102, 'Kiran'); select count(person) from sample_3 group by identy having count(person)>1 order by identy; select oid,identy,person from sample_3; /*select max(ctid) from sample_1;*/ delete from sample_3 where oid not in (select max(oid) from sample_3 group by person,identy order by person)\\ select * from sample_3 order by person; SELECT EXTRACT(year FROM NOW()) - 3; SELECT trim(' techonthenet.com ');
run
|
edit
|
history
|
help
0
test 16721723
Funciones matemáticas PostgreSQL
proj
PostreSQL: Subquery
nested array to table
E2
Descriptor test
1
3c
SQL social network practice by Han Wang 20200720