Home » RDBMS Server » Server Administration » count function
count function [message #374069] Wed, 23 May 2001 19:03 Go to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
Hi,All:
Can I use a sub query within count function?
How to use it?

Thanks
Steve

Report message to a moderator

Re: count function [message #374070 is a reply to message #374069] Wed, 23 May 2001 19:22 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
Inline views is the closest I can think of.
select count(*) from (select table_name from user_tables);

Report message to a moderator

Previous Topic: Delete Duplicate Rows
Next Topic: about nlssort
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 16:48:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.