Home » SQL & PL/SQL » SQL & PL/SQL » display total number of rows with function and criteria
display total number of rows with function and criteria [message #206514] Thu, 30 November 2006 06:54 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member


This query displays column c1, c2 and c3. The data of column c3 converts number into date from using function.

SELECT a.c1, a.c2, integerdate(a.c3)
FROM t141 a

The below query display all the tables starts with 'T' charcter.

select count(*) from user_tables where table_name like 'T%'

but I need to display total number of rows from all the above tables start start with 'T' character using the below criteria.

WHERE integerdate( c3 ) < add_months( sysdate, -36 )

Can you please write the SQL statemetn to display total number of rows from each tables start with 'T' character.

Thanks in advance.
Re: display total number of rows with function and criteria [message #206929 is a reply to message #206514] Sat, 02 December 2006 07:25 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Search for NDS - Native Dynamic SQL
Previous Topic: A function in SQL language that equals to "&" in excel
Next Topic: How to get the second highest salary from a table
Goto Forum:
  


Current Time: Sat Dec 10 05:27:20 CST 2016

Total time taken to generate the page: 0.11926 seconds