Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select distinct number statement

Status
Not open for further replies.
yytan

yytan

Programmer
Joined
May 8, 2002
Messages
113
Location
MY
hi there;

i want to select distinct "number" field from the keyword table in oracle:

rs = connect.execSQL("SELECT DISTINCT number FROM keyword WHERE keyword like '%"+ simpkeyword +"%' ");

it gave me -- missing expression -- error??

how to solve this? i understand this is the reserve word in oracle.

 
Status
Not open for further replies.

Similar threads

maas
  • Locked
  • Question Question
How to correct the update statement
Replies
1
Views
292
snitin78
snitin78
Sarky78
  • Locked
  • Question Question
trying to get number of rows in recordset but getRow() returning -3
Replies
1
Views
254
jaxtell
jaxtell
aHash
  • Locked
  • Question Question
Auto select of Select box and Submit
Replies
1
Views
244
Diancecht
Diancecht
kizzieb
  • Locked
  • Question Question
How can I redirect the session acount after the third number
Replies
1
Views
226
prosper
prosper
raf35
  • Locked
  • Question Question
how to get value of html combo box (i.e select) in jsp?
Replies
1
Views
251
sedj
sedj

Part and Inventory Search

Sponsor

Back
Top