Ho to do this? What query can be written by using select statement where all nulls should be replaced with 123?
I know we can do this y using, update tablename set fieldname = "123" where fieldname is null;
but can't do it using select statement.