Codebase list ohcount / debian/latest test / src_dir / sql1.sql
debian/latest

Tree @debian/latest (Download .tar.gz)

sql1.sql @debian/latest — raw · history · blame 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
// -----------------------------------------------------------------------
// Filename:   minvalue.sql
// Purpose:    Select the Nth lowest value from a table
// Date:       18-Apr-2001
// Author:     Deepak Rai, SSE, Satyam Computer Services Ltd. India
// -----------------------------------------------------------------------

## Comment with a hash symbol ##
select level, min('col_name') from my_table
where level = '&n'
connect by prior ('col_name') < 'col_name')
group by level;

/* a block comment
   -- finished here */

-- Example:
--
-- Given a table called emp with the following columns:
--   id   number
--   name varchar2(20)
--   sal  number
--
-- For the second lowest salary:
--
-- select level, min(sal) from emp
-- where level=2
-- connect by prior sal < sal
-- group by level
--