One way of accessing is through -->
Locking row for access select * from tab_nm;
but this would be a dirty read hence there wont be any data consistency.
I hope u were asking the same thing.
Is there any other way then grant to give access to user on any created object in teradata..if yes then what would be its syntax or command...
i have one source table..to load data from that source table to my base table i should know that for that period the data is available in table.. i wrote a query as:
sel column_name,count(1) from database.table group by column_name
order by column_name having count(1)>0;
i got output as:
i want to have a sql query which can give me date as month start date(the start date for which am getting data) and month end_Date(the last date for which am getting data) and the corresponding count for the complete period rather than having a saggrigated count for each date..please help...
You should ask a new question in a new post.
I don't completely understand what you want:
sel min(column_name),max(column_name),count(*) from database.table;
Btw, you don't need having count(1)>0 as this is always true.
I have table loaded with a date data in format 'dd-mon-yyyy' exaample '24-oct-2010' for two months sept and oct. I need to perform the minus query with the another table have the same data as the one but with the variance in date column format as date format 'yyyy-mm-dd'.
Please suggest the proper syntax to cast the date in format 'dd-mon-yyyy' to format 'yyyy-mm-dd'. so that minus operation can be performed.