Recent questions tagged sql

0 votes
1 answer

SQL Inner-join with 3 tables?

Sep 13, 2022 in Database by Kithuzzz
• 38,000 points
1,756 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

Sep 13, 2022 in Database by Kithuzzz
• 38,000 points
2,211 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

Sep 13, 2022 in Database by Kithuzzz
• 38,000 points
1,951 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Create enum in SQL Server

Sep 13, 2022 in Database by Kithuzzz
• 38,000 points
21,098 views
0 votes
1 answer
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Sep 12, 2022 in Database by Kithuzzz
• 38,000 points
7,441 views
0 votes
0 answers

Query comparing dates in SQL

Sep 12, 2022 in Database by Kithuzzz
• 38,000 points
1,295 views
0 votes
1 answer
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

Sep 11, 2022 in Database by Kithuzzz
• 38,000 points
1,313 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Sep 11, 2022 in Database by Kithuzzz
• 38,000 points
7,669 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

Sep 11, 2022 in Database by Kithuzzz
• 38,000 points
5,258 views
0 votes
1 answer

How to calculate percentage with a SQL statement

Sep 10, 2022 in Database by Kithuzzz
• 38,000 points
6,984 views
0 votes
1 answer

What are projection and selection?

Sep 10, 2022 in Database by Kithuzzz
• 38,000 points
9,341 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to execute function in SQL Server 2008

Sep 10, 2022 in Database by Kithuzzz
• 38,000 points
1,399 views
0 votes
1 answer

Calculate a Running Total in SQL Server

Sep 9, 2022 in Database by Kithuzzz
• 38,000 points
2,428 views
0 votes
1 answer

Difference between EXISTS and IN in SQL?

Sep 9, 2022 in Database by Kithuzzz
• 38,000 points
1,349 views
0 votes
1 answer

SQL Server WITH statement

Sep 8, 2022 in Database by Kithuzzz
• 38,000 points
1,213 views
0 votes
1 answer
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

Sep 8, 2022 in Database by Kithuzzz
• 38,000 points
2,371 views
0 votes
1 answer

What does the "@" symbol do in SQL?

Sep 8, 2022 in Database by Kithuzzz
• 38,000 points
1,996 views
0 votes
1 answer
0 votes
0 answers

Using If else in SQL Select statement

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,058 views
0 votes
0 answers
0 votes
0 answers

SQL update query using joins

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
1,243 views
0 votes
0 answers

Use '=' or LIKE to compare strings in SQL?

Sep 6, 2022 in Database by Kithuzzz
• 38,000 points
960 views
0 votes
0 answers

Copy data into another table

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
789 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
3,302 views
0 votes
0 answers

How to SUM two fields within an SQL query

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
1,678 views
0 votes
0 answers

How to generate a Guid in SQL Server?

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
1,250 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

Sep 5, 2022 in Database by Kithuzzz
• 38,000 points
2,878 views
0 votes
0 answers
0 votes
0 answers

Insert multiple rows into single column

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
1,864 views
0 votes
0 answers

SQL Error: ORA-00942 table or view does not exist

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
1,443 views
0 votes
0 answers

MySQL Multiple Joins in one query?

Sep 4, 2022 in Database by narikkadan
• 86,360 points
890 views
0 votes
0 answers

Dynamic Drop Down lists using ajax, sql and php

Sep 3, 2022 in Database by Kithuzzz
• 38,000 points
2,303 views
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

"CASE" statement within "WHERE" clause in SQL Server 2008

Sep 3, 2022 in Database by Kithuzzz
• 38,000 points
1,001 views
0 votes
0 answers
0 votes
0 answers

Select data from date range between two dates

Sep 2, 2022 in Database by Kithuzzz
• 38,000 points
1,369 views