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: 4502
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: Sun Dec 04 18:48:41 CST 2016

Total time taken to generate the page: 0.07194 seconds