Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
- 1 Answers
- 2429 Views
- Genpact, I also Faced
- E-Mail Answers
First we declare is as primary key and after group by we can get uniqu values.
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (ID)
);
SELECT ID, LastName,FirstName
FROM Persons
GROUP BY ID, LastName,FirstName;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Explain relational data?
What different steps will a sql server developer take to secure sql server?
What is the full form of ddl?
What is a partitioned view?
How to convert binary strings into integers in ms sql server?
What is the contrast between sql and pl/sql?
What is a data collection table?
how to retrive only second row from table in sql server 2000?
When would you use it?
How to get nth highest salary from employee table.
How can I check if a view exists in a sql server database?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
