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 • 203,286 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 • 190,784 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, 2025 • 163,854 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 • 123,420 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 • 89,703 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, 2025 • 65,239 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, 2025 • 58,947 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 • 58,642 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 • 58,017 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 • 51,620 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 • 43,152 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 • 26,337 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
 • 2,044 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, 2025 • 1,161 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 • 34,639 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 • 27,269 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 • 32,182 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 • 30,580 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 • 7,144 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 • 2,128 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 • 21,884 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 • 13,475 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 • 26,659 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, 2025 • 1,276 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 • 18,152 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 • 1,918 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 • 3,155 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 • 24,066 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 • 16,510 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 • 3,704 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 • 2,792 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, 2025 • 821 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 • 22,218 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, 2025 • 770 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, 2025 • 710 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 • 21,893 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 • 12,475 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, 2025 • 421 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 • 2,262 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 • 11,790 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 • 20,974 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, 2025 • 772 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 • 10,997 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 • 18,243 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 • 12,496 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 • 10,027 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 • 9,592 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 • 9,897 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,931 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,580 points • 17,537 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.