SELECT COMMAMD IN SQL || DML COMMANDS || SQL COMMANDS || WHERE CLAUSE || ORDER BY || SQL || DBMS

Рет қаралды 18,597

Жыл бұрын

SELECT COMMAND
Syntax
select * / col1, col2, . . . from table_name
where condition
order by
having
group by
1. DISPLAY STUDENT DETAILS WHOSE PERCENTAGE GREATER THAN 85
2. DISPLAY STUDENT DETAILS WHOSE PERCENTAGE GREATER THAN 70 AND SID GREATER THAN 103
3. DISPLAY STUDENT DETAILS WHOSE PERCENTAGE GREATER THAN 70 OR SID GREATER THAN 103
4. DISPLAY STUDENT DETAILS WHOSE PERCENTAGE NOT GREATER THAN 90
5. DISPLAY STUDENT DETAILS IN ASCENDING / DESCENDING ORDER BASED ON PERCENTAGE
6. DISPLAY FIRST 3 STUDENT DETAILS WHOSE PERCENTAGE GREATER THAN 80
7. DISPLAY TOP 3 RANKERS BASED ON PERCENTAGE FROM THE STUDENT TABLE
8. DISPLAY STUDENT DETAILS WHOSE NAME STARTS WITH 'S'
9. DISPLAY STUDENT DETAILS WHOSE NAME HAVE 'EE' ANYWHERE
10. DISPLAY STUDENT DETIALS WHOSE PERC IS EITHER 90,99,88,75
11. DISPLAY STUDENT DETIALS WHOSE PERCENTAGE IS BETWEEN 85 AND 95
--------------------------------------------------------------------------------------------------
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
• HOW TO DOWNLOAD & INST...
DATABASE MANAGEMENT SYSTEM
• DATABASE MANAGEMENT SY...
PYTHON PROGRAMS
• PYTHON PROGRAMS
C PROGRAMMING
• 01 - VARIABLES & CONST...
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
• CORE JAVA TUTORIAL FOR...
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
• HTML TUTORIALS WITH IM...
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
• LEARN CSS IN 3 HOURS |...
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
• JAVA SCRIPT FOR BEGINN...
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
• PYTHON TUTORIAL FOR BE...
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
• PYTHON - OOPS CONCEPTS...
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
• PYTHON NUMPY TUTORIAL ...
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
• PYTHON PANDAS TUTORIAL...
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
• MATPLOTLIB LIBRARY - P...
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
• PYTHON DATABASE CONNEC...
DATA STRUCTURES USING PYTHON (ENGLISH)
• DATA STRUCTURES USING ...
----------------------------------------------------------------------------------------------
Instagram : / sundeepsaradhikanthety

Пікірлер: 11

@abhishektyagi4826 Жыл бұрын

Nice Sir. I remember I was in BCA back in 2017. There was no teacher of computer graphics in my area. I watched all your lectures and scored high marks and solved all numericals instead of descriptive questions. Thanks a lot. I am now a web developer with 4 years of experience and its all possible due to selfless efforts of great teachers like you.

@bwenenzams4487 9 ай бұрын

Thank you so much sir. You really make study easy for beginners. You are a great teacher.

@ganeshjaggineni4097 Жыл бұрын

NICE SUPER EXCELLENT MOTIVATED

@rkbeats2.022 Жыл бұрын

Sir, do videos for selenium testing

@duvvugeetha9040 Жыл бұрын

Sir may i know how the above table was created,i am getting the table like when we use DESC TABLE_NAME after creating the table but not getting the students ID's and names and how to insert those names and all?