Display: account no. customer id initial amount in terms of lakhs (rounded off to 2 decimals) [change the column heading to ‘INITIALAMTIN_LAKHS’] amount category(amt < 50000 show as 'Low', amt > …
Tag: database
how to list all tables in qnx qdb
I am trying to list all tables under qnx qdb in sql. I am not able to get a suitable command. How do you list tables in a database in qdb. I am able to connect to the database but I do not know what …
How to translate an SQL statement to TypeORM query builder?
How would I convert the code below to TypeORM querybuilder? I am trying to follow the documentation. Thanks. Answer I figured it out.
mysql statmet that match exaxct “1” using regex
I want to create a regex to find a single 1 from the flowing the following list is the sample of the column value I like to search in 1,2 2,1 3,1,2 7,171,818 71,17,11 1 Note: the needed match is bolded in the prev list Answer You can go with either approach …
php add a counter in while loop and return to a new line when i reach this counter
this is my code: now this code works fine, but it echo my results on the same line since its a loop. i want my output to be 3 photos per line for example: image1 image2 image3 (jumps to line) image4 image5 image6 and not: image1 image2 image3 image4 image5 image6. To be more precise i want to add a
How to SELECT data from a postgreSQL INDEX?
If I created an index with following command: CREATE INDEX ixname ON tbname (id); Where ixname is the name of index, tbname is the table name for which the index is being created and id is the …
insert if not exists in HQL
I am trying to write a query in HQL which can insert a record if it does not exists (with same name) so that there is no duplicate insertion when done from multiple threads. However, the record is not inserted. I suspect this is because the table is empty and the subquery returns 0 records despite the NOT EXI…
How to convert date time format in SQL Server like ‘2017-03-04 10:07:03.490’ to date format which is seperated by – like ‘2-11-2016’
I am tying to make date comparison with the query but it throws this error: Msg 242, Level 16, State 3, Line 1 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. My application passes data in ’01/05/2017′ format and the date information in SQL Server i…
Invalid object name in SQL Management Studio
I’ve been creating a database for class and I’m having trouble seeing my tables. I have a total of 12 tables I have created, 3 via CREATE TABLE statements and the rest using the SQL Server Management Studio, I’m trying to enter an INSERT INTO statement but it’s not recognizing the tabl…
How to update Sql table from excel directly?
I have an sql database and I am able to connect with excel spreadsheet. But when I update the table from excel directly it’s not updating the database and once I click refresh all the entered data is …