Question for SQL Plus

From: <cheers_up_at_hotmail.com>
Date: Sat, 29 May 1999 17:54:29 GMT
Message-ID: <7ip9km$dpj$1@nnrp1.deja.com>

Hi,

Anyone could please help me to solve the following problem. Thanks in advance!

Assume, I have following records in a emp table:

        emp_id


        ------


          2
          4
          1
          5
          6

How do you write a SQL query to have the following result?

        emp_id


        ------


          2
          4
          1
          5
          6
        -----
       Total 18

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat May 29 1999 - 12:54:29 CDT