answersLogoWhite

0

To remove the decimal and numbers:

select Convert(int,12.456)

To keep the numbers after the decimal but remove the ".":

select convert(int,convert(money,12.456)*1000)

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Basic Math

What is a delete query?

A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.


How do I create a SQL Select query that will return the number of columns not rows in my query result. So if my query returns 1 row with 5 columns I want the query to generate the number 5.?

I have the same question but well a not-so-elegant solution would be to define a view within your DBMS e.g. CREATE VIEW view_name AS (SELECT ...your_query) and then apply a SELECT COUNT(*) FROM view_name


The binary number 11 would have a decimal equivalent of 11?

this isn't the fact that the binary number 11 will have decimal equivalent 11... instead it have decimal number 1011 for decimal equivalant 11.here is the alogorithms for converting the decimal number to binary equivalent...!!!#include#includevoid main(){ int i,n,j,b[100];clrscr();printf("Enter a Number:");scanf("%d",&n);i=0;while(n>0){b[i]=n%2;n=n/2;i++;}printf("\n\nBinary Equivalent:");j=i-1;for(i=j;j>=0;j--)printf("%d",b[j]);getch();}using this algorithms... the binary equivalent of any number is taken out...!!! enjoy... have any query... email at :- "devilllcreature@yahoo.com" thank you....!!!


What can a select query do?

Select query come under the category of DRL (data retrieval language). A select query is used to retrieve data from DB.


What is query in php?

query() or mysql_query() are outdated, insecure functions used for communicating queries or "requests" to a database.

Related Questions

What is a delete query?

A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.


Who would use a query?

Just about anyone who will use access will need to use a query (interrogated the data) at some point


Why selection query is first done than projection query?

Selection has more power to reduce size (Number of rows) while projection can not reduce number of tuples


How do you get just the year number in a query in Microsoft Access 2010?

Use the YEAR function, which can extract the year of a date. If your field was DOB in the query you'd have MONTH(DOB) in the field row of the query.


Can write query within the query?

Yes, you can have a query inside a query. That is known as a sub-query.


How do I create a SQL Select query that will return the number of columns not rows in my query result. So if my query returns 1 row with 5 columns I want the query to generate the number 5.?

I have the same question but well a not-so-elegant solution would be to define a view within your DBMS e.g. CREATE VIEW view_name AS (SELECT ...your_query) and then apply a SELECT COUNT(*) FROM view_name


The binary number 11 would have a decimal equivalent of 11?

this isn't the fact that the binary number 11 will have decimal equivalent 11... instead it have decimal number 1011 for decimal equivalant 11.here is the alogorithms for converting the decimal number to binary equivalent...!!!#include#includevoid main(){ int i,n,j,b[100];clrscr();printf("Enter a Number:");scanf("%d",&n);i=0;while(n>0){b[i]=n%2;n=n/2;i++;}printf("\n\nBinary Equivalent:");j=i-1;for(i=j;j>=0;j--)printf("%d",b[j]);getch();}using this algorithms... the binary equivalent of any number is taken out...!!! enjoy... have any query... email at :- "devilllcreature@yahoo.com" thank you....!!!


What is post query and pre query?

pre query


A query that prompts for input whenever it is run is a run-time query?

A query that prompts for input whenever it is run is a Paremeter Query


What is a nested query?

It is a query inside another query. Sometimes we might use one query to reduce down the amount of data to go through and then use another query based on the output of that query to get what you want. The first query is inside or nested in the first query.


What are subqueries used for in a database?

A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.A subquery is basically a query inside another query. Sometimes a main query needs to process data that is the result of another query. To extract that data a subquery could be built into a field in a main query. This is known as a subquery.


The total number of records in an opened table is displayed?

To display the total number of records in an opened table, you can use the SQL query: SELECT COUNT(*) FROM [table_name]. This query will return the total number of records present in the specified table.