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,580 points • 195,997 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 • 185,566 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 Mar 5 • 160,947 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 • 121,426 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,580 points • 85,885 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 Mar 5 • 56,098 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
 • 86,360 points • 55,019 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,580 points • 55,937 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 Mar 5 • 44,889 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 • 40,974 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,580 points • 46,288 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 • 24,696 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
 • 413 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 Mar 4 • 213 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
 • 86,360 points • 24,349 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,580 points • 30,898 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,570 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,380 points • 971 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,580 points • 28,498 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 • 12,051 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
 • 86,360 points • 19,936 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 Mar 5 • 291 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,580 points • 24,393 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 • 2,214 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 • 879 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
 • 86,360 points • 16,383 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,580 points • 22,746 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
 • 86,360 points • 14,696 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 • 21,630 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,961 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 Mar 5 • 245 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,626 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,580 points • 21,121 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 Mar 5 • 391 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 Mar 5 • 161 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 Mar 5 • 173 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,897 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,575 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 Mar 5 • 166 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
 • 86,360 points • 10,888 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,779 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,591 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
 • 86,360 points • 9,852 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
 • 86,360 points • 9,781 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
 • 86,360 points • 8,667 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 • 1,166 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
 • 86,360 points • 8,314 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
 • 86,360 points • 8,406 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 Mar 5 • 4,777 views
0 votes
1 answer

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,580 points • 15,120 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.