Recent questions tagged sql

0 votes
0 answers

Get all table names of a particular database by SQL query?

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
635 views
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

Convert SQL to LINQ Query

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
3,971 views
0 votes
0 answers

HAVING without GROUP BY

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
1,579 views
0 votes
0 answers

Select Rows with id having even number

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
2,294 views
0 votes
0 answers

SQLGrammarException: could not execute query

Aug 21, 2022 in Database by Kithuzzz
• 38,000 points
3,255 views
0 votes
0 answers
+1 vote
0 answers

SQL: Two select statements in one query

Aug 20, 2022 in Database by Kithuzzz
• 38,000 points
6,273 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

Aug 20, 2022 in Database by Kithuzzz
• 38,000 points
1,986 views
0 votes
0 answers

Find the number of columns in a table

Aug 20, 2022 in Database by Kithuzzz
• 38,000 points
442 views
0 votes
0 answers
0 votes
0 answers

How to group by month from Date field using sql

Aug 20, 2022 in Database by Kithuzzz
• 38,000 points
1,077 views
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

SQL joins as venn diagram

Aug 19, 2022 in Database by Kithuzzz
• 38,000 points
11,714 views
0 votes
0 answers

SQL Server: Invalid Column Name

Aug 19, 2022 in Database by Kithuzzz
• 38,000 points
1,522 views
0 votes
0 answers
0 votes
0 answers

CROSS JOIN vs INNER JOIN in SQL

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
710 views
0 votes
0 answers

Remove Identity from a column in a table

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
593 views
0 votes
0 answers

SQL Server FOR EACH Loop

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
5,111 views
0 votes
0 answers

Export SQL query data to Excel

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
644 views
0 votes
0 answers
0 votes
0 answers

How to Alter Constraint

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
807 views
0 votes
0 answers

Table Scan and Index Scan in SQL

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
820 views
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

SQL to find the number of distinct values in a column

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
1,117 views
0 votes
0 answers
0 votes
0 answers
0 votes
0 answers

Import CSV file into SQL Server

Aug 14, 2022 in Database by Kithuzzz
• 38,000 points
1,252 views
0 votes
0 answers
0 votes
0 answers

Left Join With Where Clause

Aug 14, 2022 in Database by Kithuzzz
• 38,000 points
879 views
0 votes
0 answers

DateTime2 vs DateTime in SQL Server

Aug 14, 2022 in Database by Kithuzzz
• 38,000 points
789 views
0 votes
0 answers

Oracle SQL: Update a table with data from another table

Aug 13, 2022 in Database by Kithuzzz
• 38,000 points
1,196 views
0 votes
0 answers
0 votes
0 answers

What represents a double in sql server?

Aug 13, 2022 in Database by Kithuzzz
• 38,000 points
832 views
0 votes
0 answers
0 votes
1 answer

Finding duplicate rows in SQL Server

Aug 13, 2022 in Data Science by Kithuzzz
• 38,000 points
671 views
0 votes
0 answers
0 votes
0 answers

Find stored procedure by name

Aug 13, 2022 in Database by Kithuzzz
• 38,000 points
627 views