SQL Query to fetch data between starting and ending null

Question

0.00/5 (No votes)

See more:

I got a requirement in some project where i need data from a table where i need to select top values that starts after a null value and than again some null values and further data

suppose table name is Data which has a column named as Company and ID column

ID Company
=== =======
1 NULL
2 NULL
3 Google
4 Microsoft
5 Oracle
6 NULL
7 NULL
8 Linked In
9 FaceBook
10 Twitter
11 NULL
12 NULL

in simple words i need to write a query that selects {Google, Microsoft and Oracle} as a result and nothing else .... its just a sample data not my actual project this data can have hundreds of values between starting null and ending null

Please provide your input to write such query
Thanks

Posted 27-May-14 3:31am

Muhammad Awais Mian

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Answer 1 · 2014-05-27T03:47:00

Solution 1

try this.. :)

SQL

select ColumnName from TableName where ColumnName <> ''

Posted 27-May-14 3:47am

Nirav Prabtani

DamithSL · Answer 2 · 2014-05-27T03:54:00

Solution 2

try below

SQL

select ID,Company from Table1 where Company is not null

Posted 27-May-14 3:54am

DamithSL

SQL Query to fetch data between starting and ending null

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

SQL Query to fetch data between starting and ending null

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us