Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

write a query to remove null following table are
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma

i want the output format like

id name
101 dinesh
102 suresh
103 prakesh

Question Posted / dinesh

Answers were Sorted based on User's Feedback



write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / kart

select * from table where id is not null;

Is This Answer Correct ?    17 Yes 3 No

write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / sumit

select id,name from table where id is not null;

Is This Answer Correct ?    4 Yes 0 No

write a query to remove null following table are id name 101 dinesh null jyothi null bha..

Answer / ajit nayak

Delete from <tab_name>
where id is null;

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

What is the difference between instead of trigger and after trigger?

0 Answers  

how to include numeric values in sql statements? : Sql dba

0 Answers  

how to create a new table in mysql? : Sql dba

0 Answers  

explain advantages of innodb over myisam. : Sql dba

0 Answers  

Explain Connect by Prior?

2 Answers  

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

What view means?

0 Answers  

What is attribute indicator in pl sql?

0 Answers  

how to concatenate two character strings? : Sql dba

0 Answers  

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories