Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL Function Support

Does this function is support in the IPCC Script in the DB Get Step ?

SELECT MAX(expression )

FROM tables

WHERE predicates;

Using IPCC version 4.0(4)_Build140

Thanks

2 REPLIES
Gold

Re: SQL Function Support

Hi,

I think that the best thing is that you try the query. You will need to deploy IPCC Express Premium version.

The Cisco documentation says this:

You cannot create Join queries that retrieve columns with the same name from

different tables. (For example, you cannot create ?select a.x, b.x from a,b? and

?select a.x as y from a?.) Similarly, you cannot make aliases of column names.

The SQL statements SELECT count(*) and SELECT min(*) are not supported.

So if select min(*) is not supported is lekely that select max(*) is no supported too. So the best thing, try it.

Hope this helps,

Juan Luis

New Member

Re: SQL Function Support

Depending on whether you have standard/premium/enhanced version, you can use the above query. If you can do DB dips, you should be able to run the above query w/o issues.

Sunil

108
Views
0
Helpful
2
Replies