Home » RDBMS Server » Server Administration » How can I avoid redundant query?
How can I avoid redundant query? [message #372141] Sun, 14 January 2001 02:39
Yun
Messages: 1
Registered: January 2001
Junior Member
In the following case, id and age are the columns of
(SOME QUERY). What kind of structure should I use to
avoid the repeating of the query without creating view?

Thanks.

------------------------------------
select id from (SOME QUERY)
where age=
(select max(age) from (SOME QUERY));

Report message to a moderator

Previous Topic: Searching between alphanumeric ranges
Next Topic: recursive queries in SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 11 02:51:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.