Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

is it possible query data that are not equal to the specified condition?

Am fetching list of users for my listview (android) i used firebaselistadapter to backing up my listview , I wanna show users data except mine . Like an sql query Select something from usertable where id!=userid;

i wanna fetch all other users data,

like image 830
sivaram636 Avatar asked Feb 18 '15 11:02

sivaram636


People also ask

Can we use not equal to in SQL query?

SQL Not Equal Operator: != When the expressions return different types of data, (for example, a string and a number), type conversion is performed. The SQL Not Equal comparison operator (!=) is used to compare two expressions. For example, 15 != 17 comparison operation uses SQL Not Equal operator (!=)

Can we use not equal to in where clause?

The SQL not equal operator is <>. You should specify this in a WHERE statement. This lets you select rows where a particular column's contents is not equal to the value you have specified. You can also use !=

What does != Mean in a query?

<> means not equal to, != also means not equal to.

How do you check for equal conditions in SQL query?

In SQL Server database, Equality Operator "=" is used to test for equality in a query. Use the following query to select the specific data where "name" = "Lily": SELECT * FROM [javatpoint].


1 Answers

Firebase currently only offers a way to include nodes based on the presence of a certain value. You cannot exclude nodes based on the presence of a value.

Update (20160828): I wrote a related answer today that shows how to detect the absence of a property.

like image 51
Frank van Puffelen Avatar answered Nov 07 '22 14:11

Frank van Puffelen