Trending questions in Database

+1 vote
1 answer

Convert excel column to comma separated list

The CONCATENATE function in Excel can transform ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 188,737 views
+1 vote
1 answer

How to Insert date value in SQL table

Always use ANSI default string literal format for date i.e. YYYY-MM-DD like below. INSERT ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points • 182,238 views
+1 vote
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

i am using in angular its work ...READ MORE

Apr 13, 2023 in Database by manisha
edited 1 day ago • 159,568 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
 • 6,370 points • 120,651 views
–1 vote
1 answer

How to add prefix in excel ?

Using the Concatenate Function in Excel, you ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 82,617 views
0 votes
1 answer

How to find 3rd highest salary in SQL

select max(salary)from employeeposition where salary <(select max(salary)from employeeposition where ...READ MORE

Oct 27, 2023 in Database by anonymous
edited 1 day ago • 53,558 views
0 votes
1 answer

How to get comma-separated values in multiple rows in SQL?

Test Data DECLARE @Table1 TABLE(ID INT, Value INT) INSERT ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 63,600 points • 51,172 views
0 votes
1 answer

Save excel as pdf changing its orientation to horizontal

To begin, go to the page layout ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 54,868 views
0 votes
0 answers

Check if table exists in SQL Server

I want this to be the last ...READ MORE

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

SQL query for distinct professors and courses

There is a database on instructors, departments, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 23,539 views
0 votes
1 answer

How to convert date to general in excel without losing format?

The steps are as follows: Copy the dates ...READ MORE

Apr 1, 2022 in Database by gaurav
 • 23,260 points • 42,859 views
0 votes
1 answer

Why is the object value not updating in MongoDB?

There could be several reasons why an ...READ MORE

Dec 31, 2024 in Database by Navya
 • 127 views
0 votes
1 answer

Convert Number to Words in Excel VBA code

1. Prevent the conversion of the cents ...READ MORE

Dec 30, 2022 in Database by bobh
edited 1 day ago • 35,567 views
0 votes
0 answers

DFS PUT Command gives error on Windows

When i run DFS PUT command on ...READ MORE

Jul 22, 2024 in Database by anonymous
edited 2 days ago • 20 views
0 votes
1 answer

SQL query - Dept and Employee table, some departments may not have managers

Yes, even though I like using JOINs, ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,600 points • 22,296 views
0 votes
1 answer

Calculate Growth rate in Excel

In order to get the Average Annual ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 29,260 views
+1 vote
0 answers

SQL: Two select statements in one query

I want to return the newly created ...READ MORE

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

what kind of a nosql store is azure table storage

what kind of a nosql store is ...READ MORE

Dec 15, 2023 in Database by Priyanka
 • 4,500 points • 737 views
0 votes
1 answer

Excel Remove Decimal Places

1) E2 is the cell from which ...READ MORE

Mar 24, 2022 in Database by gaurav
 • 23,260 points • 27,510 views
0 votes
0 answers

SQL joins as venn diagram

I've had difficulties comprehending joins in SQL, ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 11,646 views
0 votes
1 answer

Create enum in SQL Server

Just normalize your model properly: create table user_rank ( ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 63,600 points • 18,833 views
0 votes
0 answers

Cannot connect to SQL server

cannot connect to SQL worked well before ...READ MORE

Nov 10, 2023 in Database by rakshatha
edited 2 days ago • 105 views
0 votes
0 answers

Create a SQL enter script from an Excel worksheet

I have a large excel worksheet that ...READ MORE

Sep 8, 2023 in Database by Satyawrat
 • 460 points • 696 views
0 votes
0 answers

Loop in stored procedure in SQL server

Writing a stored procedure that calls another ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 1,881 views
0 votes
1 answer

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

Try replacing the string literal for date ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 63,600 points • 15,411 views
0 votes
1 answer

How do I split a cell in Excel into two or more where they are divided horizontally?

Table cells should be combined. To make a ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 22,049 views
0 votes
0 answers

MongoDB convert type of an element in array

In MongoDB, I have a object array ...READ MORE

Aug 7, 2023 in Database by Ramkumar
edited 2 days ago • 101 views
0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

I have a table Emp which has these rows: Emp_cd ...READ MORE

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

Select Rows with id having even number

I'm passing a straightforward query that looks ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 2,233 views
0 votes
1 answer

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

One of the services has not begun ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 63,600 points • 13,811 views
0 votes
1 answer

I have to convert utc time to ist in excel

There are no built-in functions for determining ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 20,388 views
0 votes
0 answers

How to create Login and Register in Laravel verify by OTP?

I want to create a project in ...READ MORE

Jul 13, 2023 in Database by Muhammad
edited 2 days ago • 6 views
0 votes
0 answers

How to add crud operation in Laravel via ajax?

I have created a project in Laravel ...READ MORE

Jul 13, 2023 in Database by Muhammad
edited 2 days ago • 5 views
0 votes
1 answer

I have a Run Time Error 91 for an Excel Add In

"Runtime Error 91: Object variable or with ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 20,376 views
0 votes
0 answers

How to Extract Tally ODBC to Sales Register table Excel, items wise In SQL Statement

How to Extract Tally ODBC to Sales ...READ MORE

Jun 17, 2023 in Database by Arun
edited 2 days ago • 6 views
0 votes
0 answers

How to fetch the nth highest salary from a table without using TOP and sub-query?

I was recently requested to create a ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 1,628 views
0 votes
1 answer

How do you count if a cell contains partial text in Excel?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 18,574 views
0 votes
1 answer

SQL SELECT WHERE field contains words

Use this query to include any of words: SELECT * ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,020 points • 20,124 views
0 votes
0 answers

How do I delete rows from two tables with ID in MySQLi using php?

I want to delete rows in two ...READ MORE

May 25, 2023 in Database by Hannes
edited 2 days ago • 9 views
0 votes
1 answer

Function vs. Stored Procedure in SQL Server

Functions are calculated values that cannot make ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points
edited Feb 17, 2022 by Neha • 19,495 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Use this: SELECT *FROM ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 63,600 points • 9,959 views
0 votes
0 answers

How to solve the system.data.sqlclient.sqlexception (0x80131904) error

I've used C# and SQL Server 2008 ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 11,193 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 9,415 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 9,015 views
0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 955 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

The unique key in your database that ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,600 points • 8,204 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 7,837 views
0 votes
1 answer

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

My date of birth change READ MORE

Feb 23, 2023 in Database by anonymous
edited 1 day ago • 4,423 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 7,874 views
0 votes
0 answers

Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

Given date: DECLARE @Date1 VARCHAR(50) = '30-01-2015' I want ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,000 points • 6,357 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.