aspose file tools
The moose likes JDBC and the fly likes how to select particular column name Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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 ?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how to select particular column name
 
Similar Threads
restrict queries in association while fetching data....
Multi-level Mapping
update query fired by hibernate!!!!
Result set type
Mapping document query