| Author |
Message |
    
Seenu454
Pilla Bewarse
Username: Seenu454
Post Number: 945
Registered: 01-2006
Posted From: 24.240.190.39
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, May 08, 2007 - 12:07 am: |    |
SELECT COUNT(*)
FROM table name
WHERE SUBSTR(CAST(EDW_START_TSP AS VARCHAR(10)),1,10) =(
SELECT MAX(SUBSTR(CAST(EDW_START_TSP AS VARCHAR(10)),1,10)) FROM table name)
anni petta mama kaani enduloo kuda oka teda undi adi max timestamp teesukoni estadi okavela oka roju records emi rakapote kuda aa mundu max time stamp ee vachudi kaani manaku ala rakudadu "zero" anni ravali ela emanna idea unda mama? |
420
Kurra Bewarse
Username: 420
Post Number: 1252
Registered: 12-2006
Posted From: 213.86.41.114
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 5:42 am: | |
<<Thanks mama
last pampindi bagundi mama adi try chesta repu>>
okay .. No problem .. leme know if u need any more Teradata info .. will recollect and help you .. |
Seenu454
Pilla Bewarse
Username: Seenu454
Post Number: 944
Registered: 01-2006
Posted From: 24.240.190.39
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:42 am: | |
Thanks mama
last pampindi bagundi mama adi try chesta repu |
Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu
Post Number: 14022
Registered: 05-2006
Posted From: 24.166.166.140
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:26 am: | |
AP .. no NL girls after marriage ... << then austrian girls???
entira a supu  |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3942
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:23 am: | |
<<how can u play with terdata when ur playing with girls in NL?>>
AP .. no NL girls after marriage ...
 |
Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu
Post Number: 14019
Registered: 05-2006
Posted From: 24.166.166.140
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:18 am: | |
how can u play with terdata when ur playing with girls in NL?
entira a supu |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3940
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:16 am: | |
Seenu454 .. this is what i recollect .. i have not played with Terradata for almost 3 years now ..  |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3939
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:15 am: | |
select count (1) from XYZ_RAM_PYAREE_TABLE
where extract(day from edw_Column)= extract(day from CURRENT_TIME) |
Aggi_pidugu
Celebrity Bewarse
Username: Aggi_pidugu
Post Number: 14014
Registered: 05-2006
Posted From: 24.166.166.140
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:11 am: | |
yeah ram pyare table kaha se aya re baba
entira a supu |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3937
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, May 07, 2007 - 12:07 am: | |
select count (1) from XYZ_RAM_PYAREE_TABLE
where edw_Column = CURRENT_TIMESTAMP
mamma make sure u truncate out the "hour/minutes/second" part in CURRENT_TIMESTAMP , so u get all the data that confers to "year/month/day".. then it should return all the records for the day u run the query |
Seenu454
Pilla Bewarse
Username: Seenu454
Post Number: 943
Registered: 01-2006
Posted From: 24.240.190.39
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, May 06, 2007 - 11:44 pm: | |
Thanks mama kaani nenu eedi datastage job lo pedata vunna
job run chesina ventanne naaku aa roju kavali mama |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3927
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, May 06, 2007 - 6:07 am: | |
select count (1) from XYZ_RAM_PYAREE_TABLE
where edw_Column
between '06-05-2007 00:00' and '07-05-2007 00:00'
 |
Seenu454
Pilla Bewarse
Username: Seenu454
Post Number: 942
Registered: 01-2006
Posted From: 24.240.190.39
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, May 06, 2007 - 3:48 am: | |
mama emi ledu naaku aa roju ki enni records vachayyo count ceyyali mama
nenu general ga select count(*)as count row from table name echa adi eppatiki enni vachayyooo ceputha undi kaani naaku aa roju ki enni vachayooo kavali
naaku timestamp ki oka column kuda undi edw_.... antu okati |
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 3926
Registered: 06-2005
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, May 06, 2007 - 3:41 am: | |
 shoot |
Seenu454
Pilla Bewarse
Username: Seenu454
Post Number: 941
Registered: 01-2006
Posted From: 24.240.190.39
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, May 06, 2007 - 3:34 am: | |
Teradata lo oka chinna simple query kavali mana db lo evarikayana idea unda? |
