Skip to content

Navigation Menu

Explore
By size
By industry
By use case
Topics
- AI
- DevOps
- Security
- Software Development
- View all
Explore
- GitHub Sponsors
  Fund open source developers
- The ReadME Project
  GitHub community articles
Repositories
- Enterprise platform
  AI-powered developer platform
Available add-ons
Pricing

Search code, repositories, users, issues, pull requests...

Search

Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Name

Query

To see all available qualifiers, see our documentation.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

leetlab11 / SQL-ALL Public

Notifications You must be signed in to change notification settings
Fork 3
Star 6

Code
Issues 1
Pull requests
Actions
Projects
Security
Insights

Additional navigation options

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Breadcrumbs

SQL-ALL

/

00627-swap-salary.sql

Latest commit

History

8 lines (6 loc) · 184 Bytes

Breadcrumbs

SQL-ALL

/

00627-swap-salary.sql

File metadata and controls

8 lines (6 loc) · 184 Bytes

1

2

3

4

5

6

7

8

-- update statement

-- update sex, but we have conditions, so update using case statement

update Salary

set sex = (case when sex = 'm' then 'f' else 'm' end)

-- apple- 2

-- yahoo- 2

Footer

© 2024 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Docs
Contact

You can’t perform that action at this time.