SQL Practice

CREATE TABLE TEST(SNO NUMBER(10));

INSERT INTO TEST values(1);

SELECT * FROM TEST;

=======================

Q)WAQ to find the duplicate name in table.

create table user1 (Id VARCHAR(20) primary key,

name VARCHAR(30), Emailid VARCHAR(30),age INTEGER);

select * from user1;

INSERT INTO user1 VALUES('O1201', 'Radhika Malhotra', 'rad12@gmail.com', 21); 

INSERT INTO user1 VALUES('O1202', 'Aryan Ray', 'Ar13@gmail.com', 25); 

INSERT INTO user1 VALUES('O1203', 'Sam Das', 'Sam1@gmail.com', 54); 

INSERT INTO user1 VALUES('O1204', 'Radhika Malhotra', 'rad12@gmail.com', 21);

INSERT INTO user1 VALUES('O1205', 'Aryan Ray', 'Ar13@gmail.com', 25);

INSERT INTO user1 VALUES('O1206', 'Radhika Malhotra', 'rad12@gmail.com', 21);   

Select name,count(*) As Occurrence FROM

user1 Group By Name having Count(*)>1;