Ask SQL Questions Online

Structured Query Language in short (SQL) is a standard database computer language for accessing databases.

Ask SQL Questions Online


Structured Query Language in short (SQL) is a standard database computer language for accessing databases. It allows the user to execute, retrieve, insert, update and delete new records, new tables and new database. SQL query is the most widely used database query as most database systems use SQL in addition to their own query. SQL was one of the first languages for Edgar F. Codd's relational model in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks" and became the most widely used language for relational databases.

SQL is easy in using and implementing in the software. Using SQL query, professionals can create micro to mega database driven site and application. But, sometime they face serious problems in implementing and using SQL in their application. But, no need to worry now because you can share your problems with us.

Our outstanding team of SQL will solve all your problems relating to SQL programming, SQL Query, SQL statement, SQL implementation in your software etc. We assure you that you will get nearly ninety nine percent accurate answers from us. Our visitors too can post the answer, as this service is open for all.

SQL is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra. Using SQL statements, users can create, manipulate and access the data. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.


Share on Google+Share on Google+

Ask SQL Questions Online

Posted on: November 23, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Ask SQL Questions Online   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
October 31, 2012
MS Sql query question

Hello, I have to tables as below. I want write a MS SQL query which will return clients that do exists in the tenants table. Please advice. My query should return Sally Hope only, as she does not have client ID in the Tenants table. Clients Client_ID Forename Surname 1 peter brook 2 Sally hope 3 steve clarke Tenants Tenants_ID Client_ID Unit town 20 1 55 Enfield 30 2 66 Herts
November 14, 2012
how can i add range for copying db to n other

Hi, i dont know whos going to get my message but im sure n expert will answer me.. im working in office where we use a software to transmit the info from one sever to n other server. the db we use is SQL ver8 to replicate date from my local server to national server we use distribution agent > publication. the problem is that if i dont run this with in 24 hr it will expire and the date wont be send to national server. so we use query on national server and that is ---------------------------------- SP_SERVEROPTION 'IMOLETTER', 'DATA ACCESS', 'TRUE' SP_COPY_LOC_TO_NAT_DB 'IMOLETTER', 'IPS4Db' ----------------------------------- where imoletter is my local office and ips4db is the national server. my question is that there is a previous date of 2 months pending. but when i run this query it will start sending the data from the beginning and it took lot of time to do that like my db is more then 5 gb. i just want to add date range for example send the data starting from oct 2012 to till now.. that will save my time and data will be submitted in no time. hope you get me fully..a if there is any option to add date range please let me know it will really ease my work and i will be grateful to you for my whole life. thanks
December 1, 2012

Basically i have a view that has car models and counts insurance policies. I need to display the Car model with the most policies. The view works fine, if i say select MAX(Counter) as MaxC from Details I get the most policies, i need the model next to it, so i tryed select MAX(Counter) as MaxC from Details where C_model = (select C_model from Details where C_model = Max(Counter) ) PLEASE HELP ME! I have been working on this for hours. regards joe
rafiq mohammad
April 24, 2013
combine sql result into single python dcitionary

I have sql query like "select col_name from tbl_name" which i am running from a python program the result is a list of dictionaries like below [{'poll_addr': ''}, {'poll_addr': ''} but i need the result in the following format with single key and all result combined with a comma [{'poll_addr': ','}], i do not want to do this in python as the query result is too large count
June 8, 2013
SQL GRANT Privilege to More than One

GRANT INSERT ON (I need to grant the user privileges to BOTH orders & orderline. Do I begin: GRANT INSERT ON orders.orderline? OR GRANT INSERT ON orders (orderline)? OR make em separate commands? or what? it is unclear. And then of course go on to TO ...blah blah blah AND MUST GRANT blahblahblah & TO blahblahblah BE on SEPARATE LINES? OR CAN IT ALL BE ON ONE LINE?
August 5, 2013
SELECT 2nd and 3rd row in TOP 3

Hi guys... i'm currently developing a news-site. So here is the problem. I want to select the 2nd and 3rd row in a TOP 3. SELECT TOP 3 * FROM News ORDER BY Date DESC; I want to remove the 1st row and only return the 2nd and 3rd row. Can anyone help?
November 17, 2013

I have a table in Oracle DB withe order count and unique IDs as columns: Order Count ID 2 1 3 2 4 4 4 5 11 6 20 8 35 9 19 12 Now I want to get a count of IDs grouped by order and separated into different buckets. For e.g. all the orders that have value <= 10 ,I need to separate the order bucket by "1" and all the orders that have value >10 and <100 I need to separate the order bucket by 10. The output for above table should be: Count(ID) Order 1 2 1 3 2 4 3 11-20 0 21-30 1 31-40 I don't want to use case statement since I have a lot of such bucket based on which I need to group the data. Please suggest how can I write the SQL query.
January 30, 2012

hi, I want to disply the max salaries from 2 tables data.pls send answer to me.
January 21, 2013

hi, first time i want to show all the data from table (eg.kamal table name) that i give "yes" for some fields...if i open second time at the same table i want to show only "non yes" should write a query in sql...plz help...