tag:blogger.com,1999:blog-4096575.post1081916281023994331..comments2024-03-19T03:20:26.726-04:00Comments on The Arup Nanda Blog: Nulls in OrderingArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4096575.post-32636472996965096432012-06-04T07:54:10.107-04:002012-06-04T07:54:10.107-04:00This is a great sharing, I m glad to read such art...This is a great sharing, I m glad to read such article. i appreciate the writer for sharing good info. Keep sharing such kind of nice info thanksdata recovery services dallashttp://www.diskdoctors.comnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-15621855843683648202011-10-11T09:36:08.715-04:002011-10-11T09:36:08.715-04:00I think better to analyze schema first.NUM_ROWS wi...I think better to analyze schema first.NUM_ROWS will not change after deletion.Ater analyze schema you will get correct num_rows.Jyothishhttps://www.blogger.com/profile/10837336864227425839noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-5842027133022696112011-07-24T21:05:16.335-04:002011-07-24T21:05:16.335-04:00Hi Arup,
I believe that you forgot to put the (DE...Hi Arup,<br /><br />I believe that you forgot to put the (DESC) ORDER BY clause in your first SELECT statement. In fact, NULL data will sort to the bottom if the sort is in ascending order (ASC) and to the top if the sort is in descending order (DESC)<br /><br />Cheers<br /><br />LegattiEduardo Legattihttps://www.blogger.com/profile/13417270391272587761noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-44008537698828055482011-05-01T01:08:31.162-04:002011-05-01T01:08:31.162-04:00@Yasir yes the index will be used.@Yasir yes the index will be used.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-82594261695960095902011-04-24T20:30:15.200-04:002011-04-24T20:30:15.200-04:00Thanks for sharing this! I could use this! By the ...Thanks for sharing this! I could use this! By the way Happy Easter!...DanielPainting workshophttp://www.oilpaintingworkshop.comnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-89734222713019593262011-04-24T16:50:56.512-04:002011-04-24T16:50:56.512-04:00It's good to know. Thanks for sharing.
Ittich...It's good to know. Thanks for sharing.<br /><br />IttichaiIttichai Chammavanijakulhttps://www.blogger.com/profile/14224567607702219584noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-30370265393031705382011-04-24T15:53:13.581-04:002011-04-24T15:53:13.581-04:00Thank you! Indeed really useful!
Wissem EL KHLIFIThank you! Indeed really useful!<br />Wissem EL KHLIFIWissemhttps://www.blogger.com/profile/15649332530072079487noreply@blogger.com