Oracle Guru's Ki Oka Question

[loveindia]

group max chestey..eventhough nuv cheppina scenario una..it picks one out of the 2 records anthey kaani..it wont give 2 records with same value.

max vaaditey..okatey ravali...thts how the function is designed.

 

Affa man, thats how group by is designed... max is just a use case of it man...

[vikuba]

he is wrong nooo aamphat man....

lets no blame him wrong...lets say he is incorrect. sounds more professional

[Kakateyudu]

modify chesina sare antey enti man?? Nuvvu cheppina scenario lo 1 ki enni dates unna max date antey okkatey pull chestundi kada?? Konchem ardam ayyettu cheppava may be with an example..

baa nuvvu ichina query ki not a group by expression ani error vastundhi.... (distinct petti kuda chusa)

 

Oka ID_num ki same created_dates vundochu.... 

 

na requirement same as this http://stackoverflow.com/questions/5815601/oracle-sql-group-by-not-a-group-by-expression-help

akkada and paina mana boys cheppinatlu partition working.....

[Kakateyudu]

distinct wont work..

Max and group by are the best...

 

assal ee Q adigina TS dev job chesthaada? if yes...he seriously is asking this q?

oh pardhuuu

baa IT job ye chestha, but SQL developer ni kaadhu but i use oracle for normal queries.... 

 

na requirement same as this http://stackoverflow.com/questions/5815601/oracle-sql-group-by-not-a-group-by-expression-help

akkada aa link lo and paina mana boys cheppinatlu partition working...... if u still feel there is a more simpler way, u are welcome to try baa... tnx..

[loveindia]

lets no blame him wrong...lets say he is incorrect. sounds more professional

plate baley maarchav ga man..

[loveindia]

baa IT job ye chestha, but SQL developer ni kaadhu but i use oracle for normal queries....

na requirement same as this http://stackoverflow.com/questions/5815601/oracle-sql-group-by-not-a-group-by-expression-help
akkada aa link lo and paina mana boys cheppinatlu partition working...... if u still feel there is a more simpler way, u are welcome to try baa... tnx..

man nuvvu first lo ichina data prakaram I told u d query.. but stack overflow daantlo extra columns unnai.. so group by is not working.. simple man..

[Kakateyudu]

man nuvvu first lo ichina data prakaram I told u d query.. but stack overflow daantlo extra columns unnai.. so group by is not working.. simple man..

yeah extra columns vunnai baa.... for understanding nenu just 2 columns ki values ye rasanu.....

 

so extra columns vunte inka partition ye option aa baa ?

 

SELECT id_num, other_id, created_date
FROM some_table
WHERE created_date in (SELECT MAX(created_date)
from some_table
GROUP BY id_num;

 

aa query kuda tried baa, it works but multiple rows vastai for id_num if they have same created_date

[CheGuevara]

is this resolved?

[vikuba]

plate baley maarchav ga man..

oka working person ni u are wrong antey...edho mob chesinattu untadhi. no plate changing balyuuu

[vikuba]

baa IT job ye chestha, but SQL developer ni kaadhu but i use oracle for normal queries.... 

 

na requirement same as this http://stackoverflow.com/questions/5815601/oracle-sql-group-by-not-a-group-by-expression-help

akkada aa link lo and paina mana boys cheppinatlu partition working...... if u still feel there is a more simpler way, u are welcome to try baa... tnx..

my bad bro. pls dont take me wrong