insert into tablename values('&name&','&no&')
Type: Posts; User: ms_plz; Keyword(s):
insert into tablename values('&name&','&no&')
DELETE FROM tablename WHERE rowid not in(SELECT MIN(rowid)FROM tablename GROUP BY column1,column2 )
SELECT UnitPrice where rownum<2 FROM (SELECT TOP 2 UnitPrice FROM Products ORDER BY UnitPrice );
SELECT top 1 UnitPrice FROM (SELECT TOP 2 UnitPrice FROM Products ORDER BY UnitPrice DESC)
create table tablename 1 from select * from tablename2