Forum

Share:

Notifications

Clear all

SQL Queries Forum
Unread Posts | Forums | Topics

SQL

Forums

Select Forum

Status

Topics

Forum

Replies

Views

Users

Date

Write a query to display the first and the last record from the Employee info table.

Other Documents

3

6

<img alt="Ramesh k" alt='' src='https://secure.gravatar.com/avatar/842bca5cb2cf5e12ced6e944bf6d51ab?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/842bca5cb2cf5e12ced6e944bf6d51ab?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

13 mins ago

13 mins ago

SQL Query to find salesmen have more than one customer

Other Documents

1

7

<img alt="Divya" alt='' src='https://secure.gravatar.com/avatar/dead06a0e94f1d0ecc4816ccf13d5e2e?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/dead06a0e94f1d0ecc4816ccf13d5e2e?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

5 hours ago

5 hours ago

write sql query to find duplicate rows in a database

Interview Questions & Answers

0

873

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

May 03

May 03

Load More Topics

PL SQL

Forums

Select Forum

Status

Topics

Forum

Replies

Views

Users

Date

PLSQL Program Sum of number between 1 to 100 using SQL

Interview Questions & Answers

0

65

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

Apr 16

Apr 16

Write a pl/sql program to display your name?

Interview Questions & Answers

0

55

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

Apr 16

Apr 16

Write a PL/SQL code to assign GRADE to every student based on their marks according to the following rules.

Topic Tags: student marks, student grade, sqlquerystudentgrade, createtablestudentgrade,

Interview Questions & Answers

2

2,501

<img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="SQL Admin" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

Dec 29

Dec 29

Load More Topics

Oracle

Forums

Select Forum

Status

Topics

Forum

Replies

Views

Users

Date

What is Oracle Cloud ? What are the advantages of Oracle Cloud?

Interview Questions & Answers

1

328

<img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='24' width='24' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="jeevan 123" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

May 29

May 29

Can we join view with table in oracle?

Topic Tags: joinviewwithtable,

Interview Questions & Answers

3

504

<img alt="KV Kumar" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="KV Kumar" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

May 14, 21

May 14, 21

SQL Query to Find the day name of 2021 new year day from Sysdate?

Topic Tags: nameof2021, newyearday, fromsysdate,

Interview Questions & Answers

2

1,143

<img alt="KV Kumar" alt='' data-srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Mahesh Karpe" alt='' src='https://secure.gravatar.com/avatar/6648bf98edf28e393d56a127881267e8?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/6648bf98edf28e393d56a127881267e8?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' />

Oct 01, 20

Oct 01, 20

Load More Topics

Data Warehousing & ERD

Forums

Select Forum

Status

Topics

Forum

Replies

Views

Users

Date

What is the best ETL tool? What are the important features of ETL tools?

Topic Tags: etltool, bestetltool, etltoolfeatures, etltoolfunctions,

Other

3

644

<img alt="Ganesh Kumaran" alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Sharavanan" alt='' src='https://secure.gravatar.com/avatar/aa770ce6007954f9dfe5afb5db948a62?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/aa770ce6007954f9dfe5afb5db948a62?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' />

Nov 09, 20

Nov 09, 20

What is slowly changing dimensions in data warehousing?

Topic Tags: slowlychangingdimensions, datawarehouseslowlychang,

Interview Questions & Answers

2

531

<img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=40&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=80&d=mm&r=g 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Deepika A" alt='' src='https://secure.gravatar.com/avatar/50a17564c6f838aa6a4dacc5df273ebe?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/50a17564c6f838aa6a4dacc5df273ebe?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 27, 20

Sep 27, 20

What is normalization in dbms?

Topic Tags: normalizationindbms, normalization,

Interview Questions & Answers

1

487

<img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' data-srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' height='40' width='40' data-src="//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Priya Roy" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="VK" alt='' src='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://sqlqueries.in/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 17, 20

Sep 17, 20

Load More Topics

Share: