Recent questions tagged sql

0 votes
1 answer

SQL Inner-join with 3 tables?

Sep 13, 2022 in Database by Kithuzzz
 • 38,000 points • 2,103 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,655 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

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

How to extract only the year from the date in sql server 2008?

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

How do I limit the number of rows returned by an Oracle query after ordering?

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

SQL Error: ORA-00922: missing or invalid option

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

Create enum in SQL Server

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

SQL Error: ORA-01861: literal does not match format string 01861

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

SQL Server Convert Varchar to Datetime

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

Query comparing dates in SQL

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

How can I confirm a database is Oracle & what version it is using SQL?

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

What's the difference between VARCHAR and CHAR?

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

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

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

DB2 SQL error sqlcode=-104 sqlstate=42601

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

Add a column with a default value to an existing table in SQL Server

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

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

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

How to calculate percentage with a SQL statement

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

What are projection and selection?

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

Add primary key to existing table

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

Difference between numeric, float and decimal in SQL Server

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

How to execute function in SQL Server 2008

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

Calculate a Running Total in SQL Server

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

Difference between EXISTS and IN in SQL?

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

SQL Server WITH statement

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

How to convert date to a format `mm/dd/yyyy`

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

SQL keys, MUL vs PRI vs UNI

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

What does the "@" symbol do in SQL?

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

Add Auto-Increment ID to existing table?

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

Using If else in SQL Select statement

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

How to return only the Date from a SQL Server DateTime datatype

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

SQL update query using joins

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

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

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

Copy data into another table

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 1,162 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,610 views
0 votes
0 answers

How to SUM two fields within an SQL query

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

How to generate a Guid in SQL Server?

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

SQL Error: ORA-00913: too many values

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

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

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

Convert Month Number to Month Name Function in SQL

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

Insert multiple rows into single column

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 2,234 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,786 views
0 votes
0 answers

Difference between Implicit Conversion and Explicit Conversion in SQL Server

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

MySQL Multiple Joins in one query?

Sep 4, 2022 in Database by narikkadan
 • 86,360 points • 1,190 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,807 views
0 votes
0 answers

Rename database name in sql server management studio 2014

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

Efficiently convert rows to columns in sql server

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

What is wrong with my SQL here? #1089 - Incorrect prefix key

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

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

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

How can I get column names from a table in SQL Server?

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

Select data from date range between two dates

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 1,655 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.