Home » Other » Training & Certification » latest sql query ask in interview
latest sql query ask in interview [message #184268] Tue, 25 July 2006 23:35 Go to next message
p.udas
Messages: 22
Registered: June 2006
Location: Pune
Junior Member
pls send me latest sql query ask in interview
as soon as possible..

Prasad
Re: latest sql query ask in interview [message #184284 is a reply to message #184268] Wed, 26 July 2006 00:47 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
How about this one?

SELECT   *
FROM     Dual
WHERE    ROWNUM = 1
CONNECT BY LEVEL = 1
START WITH LEVEL = 1
            OR ROWNUM = 1
GROUP BY CUBE(Dummy)
HAVING   GROUPING(Dummy) = 0
ORDER BY MAX(Dummy) OVER(ORDER BY Dummy);
Previous Topic: Oracle technical and functional training in India
Next Topic: pls send all sql tricky queries
Goto Forum:
  


Current Time: Wed Dec 04 02:27:54 CST 2024