[1052]tom@margo scripts $ sqlite /home/tom/sqlitetest.sldb
SQLite version 2.8.14
Enter ".help" for instructions
sqlite> create table barangan (NamaBarang text NOT NULL, CompanyID int(9));
sqlite> insert into barangan (NamaBarang, CompanyID) VALUES ('hello', 1);
sqlite> insert into barangan (NamaBarang, CompanyID) VALUES ('hello2', 2);
sqlite> SELECT rowid, NamaBarang
   ...>                          FROM barangan
   ...>                         WHERE CompanyID = '2'
   ...>                     ORDER by rowid ASC ;
2|hello2