Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Which join i have to use?
Gurjeet Singh
Feb 16 2013 2:37 AM
973
Reply
How can comibne below all select statement into one select statement.
Actaully i want max(id ) of each item into one select statement
Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='1/2')
Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='2/2')
Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='2/3')
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Combine select statements
Many Sql scripts to execute