Recent questions tagged sql

0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

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

LIMIT 10..20 in SQL Server

Sep 13, 2022 in Database by Kithuzzz
• 38,020 points
1,200 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,020 points
17,367 views
0 votes
1 answer
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Sep 12, 2022 in Database by Kithuzzz
• 38,020 points
6,088 views
0 votes
0 answers

Query comparing dates in SQL

Sep 12, 2022 in Database by Kithuzzz
• 38,020 points
847 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,020 points
563 views
0 votes
1 answer

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

Sep 11, 2022 in Database by Kithuzzz
• 38,020 points
6,635 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

Sep 11, 2022 in Database by Kithuzzz
• 38,020 points
3,706 views
0 votes
1 answer

How to calculate percentage with a SQL statement

Sep 10, 2022 in Database by Kithuzzz
• 38,020 points
5,669 views
0 votes
1 answer

What are projection and selection?

Sep 10, 2022 in Database by Kithuzzz
• 38,020 points
7,397 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,020 points
905 views
0 votes
1 answer

Calculate a Running Total in SQL Server

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

Difference between EXISTS and IN in SQL?

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

SQL Server WITH statement

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

SQL keys, MUL vs PRI vs UNI

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

What does the "@" symbol do in SQL?

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

Using If else in SQL Select statement

Sep 6, 2022 in Database by Kithuzzz
• 38,020 points
491 views
0 votes
0 answers
0 votes
0 answers

SQL update query using joins

Sep 6, 2022 in Database by Kithuzzz
• 38,020 points
636 views
0 votes
0 answers

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

Sep 6, 2022 in Database by Kithuzzz
• 38,020 points
463 views
0 votes
0 answers

Copy data into another table

Sep 5, 2022 in Database by Kithuzzz
• 38,020 points
418 views
0 votes
0 answers

Simple way to transpose columns and rows in SQL?

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

How to SUM two fields within an SQL query

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

How to generate a Guid in SQL Server?

Sep 5, 2022 in Database by Kithuzzz
• 38,020 points
671 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

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

Insert multiple rows into single column

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

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

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

MySQL Multiple Joins in one query?

Sep 4, 2022 in Database by narikkadan
• 63,720 points
443 views
0 votes
0 answers

Dynamic Drop Down lists using ajax, sql and php

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

Select data from date range between two dates

Sep 2, 2022 in Database by Kithuzzz
• 38,020 points
777 views
0 votes
0 answers