Other

SQL Query Functions – One Page Exam Notes (DBMS)

Rating

Sold

Pages

Uploaded on

18-02-2026

Written in

2025/2026

These notes cover SQL Query Functions in a clear and concise one-page format. Topics include aggregate functions, character functions, numeric functions, date functions, GROUP BY, HAVING, and ORDER BY clauses. The notes are useful for DBMS exams, quick revision, and last-minute preparation for computer science students.

Show more Read less

Institution

Course

Content preview

PROJECT :-
INCOME TAX SER
VICE SYSYTEM
BY :-

PATIL MAHI [SR25BSIT102]

JADHAV MAHESHWARI [SR25BSIT037]

PATEL VAINAVI [SR25BSIT093]

,TABLE:- INCOME

Create table income
(
i_id number(10) primary key,
payer_name varchar(30) not null,
pan_no varchar2(15),
i_amount number(10,2) check (i_amount>5000),
i_year number(5)not null);

, INSERTING VALUES IN INCOME TABLE

insert into income
values(01,'Ram','ABC001',6000,2022);

insert into income
values(02,'Neha','PQR002',7500,2023);

insert into income
values(03,'Amit','LMN003',8000,2024);

insert into income
values(04,'Sneha','EFG004',10000,2024);

insert into income
values(05,'Karan','XYZ005',12000,2025);

Report Copyright Violation

Written for

Institution: Sarvajanik University
Course: CS101

All documents for this subject (2)

Document information

Uploaded on: February 18, 2026
Number of pages: 28
Written in: 2025/2026
Type: OTHER
Person: Unknown

Subjects

sql
dbms
sql functions
aggregate function
count
sum
max
min
group by
having clause
order by clause
avg

$7.69

Get access to the full document:

Written by students who passed

Immediately available after payment

Read online or as PDF

Get to know the seller

maheshwarijadhav

Get to know the seller

maheshwarijadhav Sarvjanik

View profile

Sold

Member since

2 months

Number of followers

Documents

Last sold

0.0

0 reviews

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller maheshwarijadhav. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.69. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews) 47184 documents were sold in the last 30 days Founded in 2010, the go-to place to buy study notes for 16 years now

SQL Query Functions – One Page Exam Notes (DBMS)

Content preview

Written for

Document information

Subjects

Get to know the seller

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

What do I get when I buy this document?

Satisfaction guarantee: how does it work?

Who am I buying these notes from?

Will I be stuck with a subscription?

Can Stuvia be trusted?