jQuery in Action, 3rd edition
The moose likes Struts and the fly likes how to write sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "how to write sql query" Watch "how to write sql query" New topic

how to write sql query

smitha mano
Ranch Hand

Joined: Sep 26, 2005
Posts: 70

id name Desig
1 aaaa SA
2 bbbb PL


id street CITY
1 Pulluvazhy Perumbavoor
2 Kizhillam Pulluvazhi

i wanted to retriev data

Desig =PL the city=pulluvazhi
David Ulicny
Ranch Hand

Joined: Aug 04, 2004
Posts: 724
select e.id,e.name,e.desig from emp e where e.desig='PL'

for table address table it will be the same

SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
I agree. Here's the link: http://aspose.com/file-tools
subject: how to write sql query
It's not a secret anymore!