tag:blogger.com,1999:blog-2635979041680311167.post5679795661069349709..comments2024-03-19T20:50:33.551-04:00Comments on It's all about Data: Analytical function: ROW_NUMBER () with Qualify in TeradataUnknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2635979041680311167.post-88901927819904952702019-03-31T09:08:54.170-04:002019-03-31T09:08:54.170-04:00Hi Krishna, I hope you already know by now that wh...Hi Krishna, I hope you already know by now that why we need analytical function in SQL?Diponkar Paulhttps://www.blogger.com/profile/16468235920384508445noreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-85131202178691740572015-07-22T04:15:52.865-04:002015-07-22T04:15:52.865-04:00Why don't we write a simple select distinct st...Why don't we write a simple select distinct statement to select unique values.Krishnanoreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-60449233585398178782015-06-23T17:07:58.792-04:002015-06-23T17:07:58.792-04:00Hi Dipu,
What is the advantage of using this inst...Hi Dipu,<br /><br />What is the advantage of using this instead of "select distinct industry_code, industry"?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-18593652046435555512015-05-31T10:43:15.302-04:002015-05-31T10:43:15.302-04:00HI Dipu,
Qualify can not be used in delete state...HI Dipu,<br /><br />Qualify can not be used in delete statement. Manishnoreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-77667668032481464092015-02-01T08:58:35.561-05:002015-02-01T08:58:35.561-05:00HI Kumar, it can be used to delete the rows at the...HI Kumar, it can be used to delete the rows at the same way. For example:<br />Delete from <br />and then the code...Diponkar Paulhttps://www.blogger.com/profile/16468235920384508445noreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-44257035228518562862015-01-01T08:24:25.903-05:002015-01-01T08:24:25.903-05:00Hi,
Could you please suggest whether this code ca...Hi,<br /><br />Could you please suggest whether this code can be converted to delete the duplicate recordsAnonymoushttps://www.blogger.com/profile/04532380148214054939noreply@blogger.comtag:blogger.com,1999:blog-2635979041680311167.post-74861946427546531452015-01-01T08:23:16.640-05:002015-01-01T08:23:16.640-05:00Hi,
Could you please confirm whether this applies...Hi,<br /><br />Could you please confirm whether this applies for deleting the dupes as wellAnonymoushttps://www.blogger.com/profile/04532380148214054939noreply@blogger.com