Explore SQL on Experts Exchange

Expert Solutions for Your Tech Problems

SQLSQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....

Read more
  • 61K Content
  • 7.8K Contributors

Expert Spotlight
Shaun Vermaak
COG Lead Engineer

I'm Shaun Vermaak. I love tech and how it improves life and business. Did you find what you were looking for?

Post

How to replace Dlookup and Dsum In MS Access  Many …

byHankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
How to replace Dlookup and Dsum In MS Access

Many beginners struggle to replace Domain functions …
Post

Greetings.  I learnt about various types of real-time …

byAm P
Greetings.

I learnt about various types of real-time problems that doesnt occur in day-to-day …
Post

Today I was facing a technical issue to transform my data in…

byRyan Chong
Today I was facing a technical issue to transform my data in spark sql, it's kind of unpivot a …
Post

Advanced report examples in SQL Server using PIVOT and …

byRyan Chong
Advanced report examples in SQL Server using PIVOT and GROUPING SETS

…
Post

Performance Comparison of (SELECT TOP 1) Verses MAX() …

byRyan Chong
Performance Comparison of (SELECT TOP 1) Verses MAX()
…
Post

SQL Server: Split strings the right way – or the next best …

byRyan Chong
SQL Server: Split strings the right way – or the next best way

…
Post

AccessUserGroups.org launched a new tool that will convert …

byMark Edwards
AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL.  If you…
Post

How to implement error handling in SQL Server  …

byRyan Chong
How to implement error handling in SQL Server

…
Post

Query data with no SQL code in SQL Server A beginner free …

byMáté Farkas
Query data with no SQL code in SQL Server
A beginner free course for analysist and everyone …
Post

For those of you working with Access / Office 365  with SQL …

byJim Dettman (EE MVE)
For those of you working with Access / Office 365  with SQL Server back ends, and are on the current…
Post

Troubleshooting slowness of your queries in SQL Server?  …

byRyan Chong
Troubleshooting slowness of your queries in SQL Server?

Why Is My SQL Server Query Running So …
Post

SQL Server: Concatenate Multiple Rows Into Single String  …

byRyan Chong
SQL Server: Concatenate Multiple Rows Into Single String

…
Post

Microsoft Access Query is Corrupt errors.    Earlier this…

byLuke Chung
1
Microsoft Access Query is Corrupt errors.


Earlier this week, Microsoft released several…
Post

How get data from SQL server in batches and then store it …

bySAMIR BHOGAYTA
How get data from SQL server in batches and then store it excel.

When we faced an issue …
Post

Ranking rows in Microsoft Access    To rank something …

byGustav Brock
Ranking rows in Microsoft Access


To rank something isn't that difficult. Basically, …
Post

DJoin  As you can union records, you can join field …

byGustav Brock
DJoin
As you can union records, you can join field values. Presented here, DJoin offers …
Post

I need to write  query   retrieve the loan number, state and…

bybeete hime
1
I need to write  query   retrieve the loan number, state and city, customer first name for loans …
Post

SQL Server Management Studio : Windows Authentication from a…

byOlivier Marchetta
SQL Server Management Studio : Windows Authentication from a non-domain-joined computer.

When …
Post

I haven't worked with SQL Server since 2001. Now I'm trying …

byDolores Hardy
9
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Post

Sequential or Random Rows in Microsoft Access  Study my …

byGustav Brock
1
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more