Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Unique key and Single Query

This is a discussion on Unique key and Single Query within the SQL forums, part of the Databases category; Suppose we have defined a unique on a column of a table? So at max how many null values can one insert for the same column. Also using Single query ...

Geeks Talk > Databases > SQL Unique key and Single Query

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-10-2008

mail2das.ashok Junior Member   Join Date: Jan 2007 Location: India Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Unique key and Single Query Suppose we have defined a unique on a column of a table? So at max how many null values can one insert for the same column. Also using Single query how to display numbers from 1 to 100

Sponsored Links

#2 (permalink)   02-11-2008

susarlasireesha Expert Member   Join Date: Apr 2007 Location: Bangalore Posts: 447 Thanks: 20 Thanked 54 Times in 54 Posts

Re: Unique key and Single Query select rownum from sys.all_tables where rownum <=100 ;

#3 (permalink)   02-11-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: Unique key and Single Query You can insert any number of null values as NULL is not a value . and NULL <> NULL.

Geeks Talk > Databases > SQL

« Print last 3 rows in a table | Insert in a table »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Employee and manager name in single query	Geek_Guest	SQL	13	07-17-2008 12:07 PM
Insert of multiple records in single query	ramvidhu	SQL Server	5	07-03-2007 08:53 AM
Unique with NotNull??	vcyogi	SQL Server	2	06-08-2007 10:15 AM
How to rectify this using a single update query	pjitu1969	SQL	2	03-18-2007 03:14 AM
Single doubt on Single Call Object	norman	ASP.NET	0	08-29-2006 12:24 PM

All times are GMT -4. The time now is 07:21 PM.