Hi 
I have a database with following structure
 NO |  Emp Name | Emp Desc
  1          EMP1       this is EMP1
  2          EMP2        this is EMP2  
I want to search this database I will search Emp Name & Emp Desc for example
If Search EMP I will get results as EMP1 , this is EMP1, EMP2, this is EMP2.
I need to order this search in such a way that I get the Emp Name Column
first then I will get the Emp Desc Column. So the result should be as
follows. EMP1, EMP2, this is EMP1, this is EMP2. Is it possible to implement
this in one query in Sqlite ???
-- 
View this message in context: 
http://old.nabble.com/SQLite-ordering-data-from-multiple-columns-tp32900541p32900541.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to