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

Показать описание

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

DATABASE MANAGEMENT SYSTEM

PYTHON PROGRAMS

C PROGRAMMING

CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS

HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS

LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS

JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT

PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)

PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)

PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU

PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE

MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)

PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL

DATA STRUCTURES USING PYTHON (ENGLISH)

----------------------------------------------------------------------------------------------

Рекомендации по теме

Комментарии

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.

abhishektyagi

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

bwenenzams

Sir kindly also tell the queries for Oracle

vinantirangwani

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?

duvvugeetha

In order by clause "desc" keyword is not working can u help me how to resolve that problem. It shows wrong output.

sidda.manisha

Email id syntax and exam cheppara please

pen_edits_videos

it's not a DML command it"s the DRL command

susantakumarojha

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

5 Basic SELECT Statement Queries in SQL

SQL SELECT Tutorial |¦| SQL Tutorial |¦| SQL for Beginners

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

SELECT query in SQL - Retrieval of records from a table

How to Write Basic SQL Statements (SELECT, FROM)

SQL Select Statement Tutorial | SQL Select Query Explained | SQL Tutorial For Beginners | SimpliCode

SQL - Part 3 - Select Command

SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5

Oracle - SQL - Select Statement

The SQL SELECT Statement

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Select statement in sql server - Part 10

GROUP BY & HAVING CLAUSE IN SELECT COMMAMD || SQL COMMANDS || GROUP BY || HAVING || SQL || DBMS

SELECT TOP Statement | SQL Tutorial for Beginners

SQL SELECT Statement #shorts

7. What is Data Query Language (DQL) in SQL? Introduction to the SELECT Command in MySQL.

SQL SELECT DISTINCT statement (return different values) | SQL Tutorial for Beginners | 2021

SQL Query Basics: Insert, Select, Update, and Delete

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Select Command in SQL | AND | OR | NOT in SQL | In Hindi

Sql server select where in list

SQL SELECT INTO

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

SQL Tutorial #26 - SQL INSERT INTO SELECT Statement Example