create table employee(emp_id int primary key, emp_name nvarchar(60), emp_age int, emp_city nvarchar(60)); insert into employee values(1,'Programmer',21,'Hyderabad') insert into employee values(2,'telugu',32,'Bengalore') insert into employee values(3,'John',34,'Mumbai') insert into employee values(4,'John',24,'Mumbai') insert into employee values(5,'Programmer',25,'Hyderabad') insert into employee values(6,'Sam',40,'Hyderabad') select emp_id,emp_name from employee select * from employee drop table employee
DISTINCT ki Examples asalu sariga cheppaledu Bro meeru..... Mee way of Explanation bagundi but Examples inkonchem neat ga chepthe baga artham avthundi Bro..... @teluguprogrammer
Delete can be used to delete specific records or entire records of the table. but, Drop can be used to delete the table/database at a time. explanation: when you want delete data in table then u can use DELETE, when you wnat to delete the table then u can use DROP.
![What is SQL? [in 4 minutes for beginners]](http://i.ytimg.com/vi/27axs9dO7AE/mqdefault.jpg)
Your teaching superb sir
Continue classes please
chala arthavanthanga chepparu sir meeru, sql purthiga nerchukovachu
thank you so much sir, this videos are helpful me to learn easily within few days
Please explain difference between DBMS and Nosql your explain very nice
Excellent explanation n voice
Excellent explanation ❤
Thank you..sir . That's help full.
Thank you sir... you help us
Delete ayya navi Ela retrieve cheyyochu & undo option utadha
It's so helpful bro
Identity is not working in mysql workbench. Could you please tell is identity will work in all SQL servers???
create table employee(emp_id int primary key, emp_name nvarchar(60), emp_age int, emp_city nvarchar(60));
insert into employee values(1,'Programmer',21,'Hyderabad')
insert into employee values(2,'telugu',32,'Bengalore')
insert into employee values(3,'John',34,'Mumbai')
insert into employee values(4,'John',24,'Mumbai')
insert into employee values(5,'Programmer',25,'Hyderabad')
insert into employee values(6,'Sam',40,'Hyderabad')
select emp_id,emp_name from employee
select * from employee
drop table employee
sir can u send ppt as well for reading
Oka Vela DDL,DML,DCL and TCL commands nerchukuni SQL Developer Avvocha?
JAVA meedha Real-Time expert Avvali Bro please Help me!
Pls do a video on store procedure and I have mailed you but I didn't get any cl from ur side
Super gaa chepparu anna
Sir me playlist topics cover cheste sql vachinattena
Are there any options like undo or redo.it will help, while in case any mistake happens in UPDATE or DELETE
No brother, we can't restore the data once we delete and update functions. so that we need to be careful while using update and delete functions.
rollback(DML COMMANDS) avilable for undo ,not for DDL commands(its auto commit)
hai sir sql real time project explanation kaavali
Have u got reply from them.. I want to learn sql real-time projects
DISTINCT ki Examples asalu sariga cheppaledu Bro meeru..... Mee way of Explanation bagundi but Examples inkonchem neat ga chepthe baga artham avthundi Bro..... @teluguprogrammer
it is not come column 4 value sir please explain about this error
TQ
SIR
Hello sir maile ku number pampinchanu inka replay raledhu sir
Diff between drop and delete
Delete can be used to delete specific records or entire records of the table.
but, Drop can be used to delete the table/database at a time.
explanation: when you want delete data in table then u can use DELETE,
when you wnat to delete the table then u can use DROP.
@@manipalukuru319super brother
Well said brother 🎉
Ms SQL material undha sir
13:13
Employee type filter cheydam chupinddi
Hi sir I need classrs
miku mail send chesha kani reply ledu
Hi, sir my self Nazeer
You missed '*' symbol in where syntx in notes sir.
Thank you
Hello sir
hii
Super bro 🫡🫡🫡🫡
Hii
Mail chasena reply ledu sir. 😔
no i did not received your email. you have to send email to teluguprogrammer.tips@gmail.com
@@TeluguProgrammerTips please check I sir. Know also I sent a mail.
Me too sent an email.. No reply
Hlo sir next video upload cheyaled Niki Mali chesam no reply led
i didn’t received your email
Mobile number sent chesa sir ,but no response
Me too.. Have u got call from them
very good clarification bro, thank you so much for your support.