[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Getting a "rowid" from a view
From:       Kit <kit.saels () gmail ! com>
Date:       2010-05-30 14:31:47
Message-ID: AANLkTil1CUEIhFUFJ0TfG6XvHM58EaAtxoCHCtYHPZEV () mail ! gmail ! com
[Download RAW message or body]

2010/5/29 Jim Terman <jterman@tivo.com>:
> Say I have a table of phone numbers
>
> CREATE TABLE phonebook (first_name TEXT, last_name TEXT, phone_number TEXT);
>
> I want to sort this by name, so I create a view
>
> CREATE VIEW phonebook_order AS SELECT first_name, last_name,
> phone_number FROM phonebook ORDER BY last_name, first_name;

CREATE VIEW phonebook_order AS SELECT rowid, first_name, last_name,
phone_number FROM phonebook ORDER BY last_name, first_name;
-- 
Kit
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]