Can we use more than one null value for unique key?
- 31 Answers
- 59889 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavani
No, we can't use more than one null value for unique key.
Unique means it doesn't accept duplicate values.
| Is This Answer Correct ? | 41 Yes | 67 No |
What are the different types of functions in sql?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
What is pls integer?
I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?
What are Lexical Parameters.How They are used in Reports 6i
What are the two types of periodical indexes?
How can I make sql query run faster?
Why self join is used in sql?
What is difference between Procedures and Functions ?
What is the difference between cross join and natural join?
Which sql statement is used to return only different values?
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
