SkillBuilders: Advanced SQL Queries Course Overview

[fishercat73]

There's a free 1-hour technical video lesson on Oracle Analytic functions (advanced SQL) here SkillBuilderscom/webinars Lots of other good videos too.

[fishercat73]

Great session

[visualsuccess]

Would have been nicer to see some actual course activities and less advertisement.

[irfanansari85]

plsea tell me about this query

select name,date,sum(totle) from table where name='ali' group by name,date

this not give sum as sum should be please tell me why

[skillbuildersDotcom]

@irfanansari85 not sure what you mean by "this not give sum as sum"

[visualsuccess]

@irfanansari85

Try looking for "Introduction to SQL Update Subselect "

[TheGoldenArmor]

as u put where clause

he will get sum for only users whose name is just ali

if u have one ali

so sum is unuseful here

[Jilf]

so cool

[clay4him]

cool