My problem is i have a two tablestable1customercustid custnametable2custaddrcustaddrid custaddrstr custid datei have different records for each custid in custaddr table. say for example for the first customer we have 6 records in custaddr table. so i want the latest dated record from the custaddr table. ie to find the maximum date. pls somebody can write the query for this, i have tried but not able to find the max of the dates.thanks in advance
Latest Answer : select * from emp where rowid=(select max(rowid) from emp); ...
Latest Answer : you can use the "rownum" column of the table. likeselect max(rownum) from tableName.select * from tableName where rownum = (fetched rownum) ...
What is the function used to find the length of the string in teradata sql which i want to run in mainframe. say other than length.
Write a query that display the records based on condition. excluding the record that meets the condition Eg... Select all employees who has same salary as empno 20. My query should return all the rows excluding empno20.
1. what is a reverse key index and it's real time usage 2. Difference Between Hash Join & Merge Join 3. Difference between Optimizer=ALL_ROWS and Optimizer=CHOOSE 4. What is the meaning of cost, card, Bytes? 5. What is syntax for dropping a procedure and a function .Are these operations possible? 6. How you were passing cursor variables in PL/SQL 2.2? 7. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 8. What is use of a cursor variable? How
How to insert a record in two tables with single insert statement ?
Latest Answer : Using merge concept, we can insert a record at a time into two tables. ...
Describe variable length record representation in files using byte string representation
What could be the maximum size of a database name in MSQL?
