GeeCON Prague 2014*
The moose likes JDBC and the fly likes how to select particular column name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to select particular column name" Watch "how to select particular column name" New topic
Author

how to select particular column name

nagesh babu
Greenhorn

Joined: Feb 13, 2007
Posts: 1
Hi,

I have a table with four fields which contains only boolean values.

At any point of time, only one field can be true.

can anyone help me in writing the query for the getting the column name that has "true" value.

Thanks,
nageshbabu
Srikanth Basa
Ranch Hand

Joined: Jun 06, 2005
Posts: 241
Which database you are using ?
 
GeeCON Prague 2014
 
subject: how to select particular column name