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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select from one select 1

Status
Not open for further replies.
Diogo

Diogo

Technical User
Mar 22, 2001
143
PT
Hello.

Can i make a "select" where the "from" is the result of another select.

In db2 is something like this:
"select * from (select * from table) as temp."

Thanks any way...
DR
 
Sort by date Sort by votes
Diogo,
I'm not sure, but I don't think you can use this syntax(i tried and didn't work), but this type of syntax works in PostgreSql.

Gragi
 
Upvote 0 Downvote
Thanks.

I already was to suspect that.

DR
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Aurillius
  • Locked
  • Question
Select first complete row from each group
Replies
1
Views
206
Aurillius
Aurillius
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
207
arunkumar.ceg
arunkumar.ceg
Stinney
  • Locked
  • Question
Select from Select? 1
Replies
4
Views
136
Stinney
Stinney
enriquegm82
  • Locked
  • Question
getting username from an informix 4gl program 1
Replies
3
Views
399
PHV
PHV
albatross68
  • Locked
  • Question
SELECT MAX(col) .. WHERE produces the wrong result
Replies
0
Views
103
albatross68
albatross68

Part and Inventory Search

Sponsor

Back
Top